#1 Support for Oracle Data Types
Please add support to
DIALOG.Generator.FrameworkGenerator.GetCSharpTypeNa
me for ORACLE datatypes. Complete list follows.
1 VARCHAR2( size)
[BYTE | CHAR]
Variable-length character string having maximum
length size bytes or characters. Maximum size is
4000 bytes, and minimum is 1 byte or 1 character.
You must specify size for VARCHAR2.
BYTE indicates that the column will have byte
length semantics; CHAR indicates that the column
will have character semantics.
1 NVARCHAR2( size) Variable-length character string
having maximum
length size characters. Maximum size is
determined by the national character set definition,
with an upper limit of 4000 bytes. You must specify
size for NVARCHAR2.
2 NUMBER( p,s) Number having precision p and scale s.
The precision p can range from 1 to 38. The scale s can
range from -84 to 127. 8 LONG Character data of
variable length up to 2 gigabytes, or 231 -1 bytes.
12 DATE Valid date range from January 1, 4712 BC to
December 31, 9999 AD.
180 TIMESTAMP
( fractional_
seconds_precision)
Year, month, and day values of date, as well as hour,
minute, and second values of time, where
fractional_seconds_precisionis the number
of digits in the fractional part of the SECOND
datetime field. Accepted values of fractional_
seconds_precision are 0 to 9. The default is 6.
181 TIMESTAMP
( fractional_
seconds_precision)
WITH TIME ZONE
All values of TIMESTAMP as well as time zone
displacement value, where fractional_
seconds_precisionis the number of digits in the
fractional part of the SECOND datetime field.
Accepted values are 0 to 9. The default is 6.
231 TIMESTAMP
( fractional_
seconds_precision)
WITH LOCAL TIME
ZONE
All values of TIMESTAMP WITH TIME ZONE, with
the following exceptions:
n Data is normalized to the database time zone
when it is stored in the database.
n When the data is retrieved, users see the data in
the session time zone.
a The codes listed for the datatypes are used internally
by Oracle. The datatype code of a column
or object attribute is returned by the DUMP function.
Datatypes
2-8 Oracle9 i SQL Reference
182 INTERVAL YEAR
( year_precision) TO
MONTH
Stores a period of time in years and months, where
year_precision is the number of digits in the
YEAR datetime field. Accepted values are 0 to 9. The
default is 2.
183 INTERVAL DAY ( day_
precision) TO
SECOND
( fractional_
seconds_precision)
Stores a period of time in days, hours, minutes, and
seconds, where
n day_precision is the maximum number of
digits in the DAY datetime field. Accepted
values are 0 to 9. The default is 2.
n fractional_seconds_precision is the
number of digits in the fractional part of the
SECOND field. Accepted values are 0 to 9. The
default is 6.
23 RAW( size) Raw binary data of length size bytes.
Maximum
size is 2000 bytes. You must specify size for a
RAW value.
24 LONG RAW Raw binary data of variable length up to 2
gigabytes.
69 ROWID Base 64 string representing the unique
address of a
row in its table. This datatype is primarily for values
returned by the ROWID pseudocolumn.
208 UROWID [( size)] Base 64 string representing the
logical address of a
row of an index-organized table. The optional size
is the size of a column of type UROWID. The
maximum size and default is 4000 bytes.
96 CHAR( size)[BYTE |
CHAR]
Fixed-length character data of length size bytes.
Maximum size is 2000 bytes. Default and
minimum size is 1 byte.
BYTE and CHAR have the same semantics as for
VARCHAR2.
96 NCHAR( size) Fixed-length character data of length
size
characters. Maximum size is determined by the
national character set definition, with an upper limit
of 2000 bytes. Default and minimum size is 1
character.
These datatypes are used for character data:
n CHAR Datatype
n NCHAR Datatype
n NVARCHAR2 Datatype
n VARCHAR2 Datatype
112 CLOB A character large object containing single-byte
characters. Both fixed-width and variable-width
character sets are supported, both using the CHAR
database character set. Maximum size is 4 gigabytes.
112 NCLOB A character large object containing Unicode
characters. Both fixed-width and variable-width
character sets are supported, both using the NCHAR
database character set. Maximum size is 4 gigabytes.
Stores national character set data.
113 BLOB A binary large object. Maximum size is 4
gigabytes.
114 BFILE Contains a locator to a large binary file stored
outside the database. Enables byte stream I/O
access to external LOBs residing on the database
server. Maximum size is 4 gigabytes.
--Eric.
Logged In: YES
user_id=998697
Tossing this back over to you Eric as you mentioned that you
already had this implemented in the existing
GetCSharpTypeName function; however, I have now added a
new class called TypeMapper under Framework\SQLServer.
We need to add a new file for Oracle type support,
Framework\Oracle\TypeMapper.cs. Simply pattern it after
the SQLServer\TypeMapper.cs.