Type (OraAttribute) Property
Applies To
OraAttribute Object
Description
A integer code representing the Server type of this attribute.
Usage
typecode = OraAttribute.Type
Remarks
These integer codes correspond to external data types in OCI8. The codes are:
ORATYPE_VARCHAR2
| -
|
ORATYPE_NUMBER
| 2
|
ORATYPE_SINT
| 3
|
ORATYPE_FLOAT
| 4
|
ORATYPE_STRING
| 5
|
ORATYPE_DECIMAL
| 7
|
ORATYPE_VARCHAR
| 9
|
ORATYPE_DATE
| 12
|
ORATYPE_REAL
| 21
|
ORATYPE_DOUBLE
| 22
|
ORATYPE_UNSIGNED8
| 23
|
ORATYPE_UNSIGNED16
| 25
|
ORATYPE_UNSIGNED32
| 26
|
ORATYPE_SIGNED8
| 27
|
ORATYPE_SIGNED16
| 28
|
ORATYPE_SIGNED32
| 29
|
ORATYPE_PTR
| 32
|
ORATYPE_OPAQUE
| 58
|
ORATYPE_UINT
| 68
|
ORATYPE_RAW
| 95
|
ORATYPE_CHAR
| 96
|
ORATYPE_CHARZ
| 97
|
ORATYPE_CURSOR
| 102
|
ORATYPE_ROWID
| 104
|
ORATYPE_MLSLABEL
| 105
|
ORATYPE_OBJECT
| 108
|
ORATYPE_REF
| 110
|
ORATYPE_CLOB
| 112
|
ORATYPE_BLOB
| 113
|
ORATYPE_BFILE
| 114
|
ORATYPE_CFILE
| 115
|
ORATYPE_RSLT
| 116
|
ORATYPE_NAMEDCOLLECTION
| 122
|
ORATYPE_COLL
| 122
|
ORATYPE_SYSFIRST
| 228
|
ORATYPE_SYSLAST
| 235
|
ORATYPE_OCTET
| 245
|
ORATYPE_SMALLINT
| 246
|
ORATYPE_VARRAY
| 247
|
ORATYPE_TABLE
| 248
|
ORATYPE_OTMLAST
| 320
|
These codes are also listed in the ORACONST.TXT file located in the
ORACLE_HOME\OO4O directory.
Data Type
Integer