OraIDataType Property
See Also
Applies To
OraField
Description
Returns the Oracle internal data type code for the field specified. Not
available at design time and read-only at run time.
Usage
field_idatatype = orafield.OraIDataType
Remarks
The following Oracle Internal Data Types will be returned.
Constant
| Value
| Internal DataType
|
ORATYPE_VARCHAR2
| -
| VARCHAR2
|
ORATYPE_NUMBER
| 2
| NUMBER
|
ORATYPE_LONG
| 8
| LONG
|
ORATYPE_DATE
| 12
| DATE
|
ORATYPE_RAW
| 23
| RAW
|
ORATYPE_LONGRAW
| 24
| LONG RAW
|
ORATYPE_CHAR
| 96
| CHAR
|
ORATYPE_MLSLABEL
| 106
| MLSLABEL
|
ORATYPE_OBJECT
| 108
| OBJECT
|
ORATYPE_REF
| 110
| REF
|
ORATYPE_CLOB
| 112
| CLOB
|
ORATYPE_BLOB
| 113
| BLOB
|
ORATYPE_BFILE
| 114
| BFILE
|
ORATYPE_VARRAY
| 247
| VARRAY
|
ORATYPE_TABLE
| 248
| NESTED TABLE
|
These values can be found in the file ORACONST.TXT.
Data Type
Long Integer