OraIDataType Property

See Also

Applies To

OraField

Description

Returns the Oracle internal datatype 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 datatypes will be returned.

Constants

Constant	Value	Internal Datatype
ORATYPE_VARCHAR2		VARCHAR2
ORATYPE_NUMBER	2	NUMBER
ORATYPE_DATE	12	DATE
ORATYPE_RAW	95	RAW
ORATYPE_CHAR	96	CHAR
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_VARRAY	247	VARRAY
ORATYPE_TABLE	248	NESTED TABLE

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

Data Type

Long Integer