OraIDataType Property

Applies To

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

Data Type

Long Integer

Remarks

The following Oracle Internal data types are returned.

Constant	Value	Internal Data Type
`ORATYPE_VARCHAR2`	`1`	`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_BFLOAT`	`100`	`BINARY_FLOAT`
`ORATYPE_BDOUBLE`	`101`	`BINARY_DOUBLE`
`ORATYPE_MLSLABEL`	`105`	`MLSLABEL`
`ORATYPE_OBJECT`	`108`	`OBJECT`
`ORATYPE_REF`	`110`	`REF`
`ORATYPE_CLOB`	`112`	`CLOB`
`ORATYPE_BLOB`	`113`	`BLOB`
`ORATYPE_BFILE`	`114`	`BFILE`
`ORATYPE_TIMESTAMP`	`187`	`TIMESTAMP`
`ORATYPE_TIMESTAMPTZ`	`188`	`TIMESTAMP WITH TIME ZONE`
`ORATYPE_INTERVALYM`	`189`	`INTERVAL` `YEAR` `TO` `MONTH`
`ORATYPE_INTERVALDS`	190	`INTERVAL` `DAY` `TO` `SECOND`
`ORATYPE_TIMESTAMPLTZ`	`232`	`TIMESTAMPWITHLOCALTIMEZONE`
`ORATYPE_VARRAY`	`247`	`VARRAY`
`ORATYPE_TABLE`	`248`	`NESTED` `TABLE`

These values can be found in the ORACLE_BASE\\ORACLE_HOME\oo4o\oraconst.txt file.