| 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 |
|
The following are Oracle datatype codes.
| Oracle Datatype |
Codes |
|---|---|
| ORATYPE_VARCHAR2 |
1 |
| ORATYPE_NUMBER |
2 |
| ORATYPE_SINT |
3 |
| ORATYPE_FLOAT |
4 |
| ORATYPE_STRING |
5 |
| ORATYPE_DECIMAL |
7 |
| ORATYPE_LONG |
8 |
| ORATYPE_VARCHAR |
9 |
| ORATYPE_DATE |
12 |
| ORATYPE_REAL |
21 |
| ORATYPE_DOUBLE |
22 |
| ORATYPE_UNSIGNED8 |
23 |
| ORATYPE_RAW |
23 |
| ORATYPE_LONGRAW |
24 |
| 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_CHAR |
96 |
| ORATYPE_CHARZ |
97 |
| ORATYPE_BFLOAT |
100 |
| ORATYPE_DOUBLE |
101 |
| 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_TIMESTAMP |
187 |
| ORATYPE_TIMESTAMPTZ |
188 |
| ORATYPE_INTERVALYM |
189 |
| ORATYPE_INTERVALDS |
190 |
| ORATYPE_SYSFIRST |
228 |
| ORATYPE_TIMESTAMPLTZ |
232 |
| ORATYPE_SYSLAST |
235 |
| ORATYPE_OCTET |
245 |
| ORATYPE_SMALLINT |
246 |
| ORATYPE_VARRAY |
247 |
| ORATYPE_TABLE |
248 |
| ORATYPE_OTMLAST |
320 |
| ORATYPE_RAW_BIN |
2000 |
oraconst.txt file located in the ORACLE_BASE\ORACLE_HOME\oo4o directory.
 Oracle Copyright © 1994, 2003 Oracle Corporation All Rights Reserved. |
|