| Oracle® Objects for OLE Developer's Guide 10g Release 1 (10.1) Part Number B10118-01 |
|
| Oracle® Objects for OLE Developer's Guide 10g Release 1 (10.1) Part Number B10118-01 |
|
Applies To
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 |
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 |
TIMESTAMP WITH LOCAL TIME ZONE |
| ORATYPE_VARRAY |
247 |
VARRAY |
| ORATYPE_TABLE |
248 |
NESTED TABLE |
ORACLE_BASE\ORACLE_HOME\oo4o\oraconst.txt.
Data Type
Long Integer
 Oracle Copyright © 1994, 2003 Oracle Corporation All Rights Reserved. |
|