Oracle Objects for OLE
Release 9.2

Part Number A95895-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents

Master Index

Feedback

Oracle Datatypes

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_VARCHAR
9
ORATYPE_DATE
12
ORATYPE_REAL
21
ORATYPE_DOUBLE
22
ORATYPE_UNSIGNED8
23
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_RAW
95
ORATYPE_CHAR
96
ORATYPE_CHARZ
97
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_SYSFIRST
228
ORATYPE_SYSLAST
235
ORATYPE_OCTET
245
ORATYPE_SMALLINT
246
ORATYPE_VARRAY
247
ORATYPE_TABLE
248
ORATYPE_OTMLAST
320
ORATYPE_RAW_BIN
2000

These codes are also listed in the oraconst.txt file located in the ORACLE_BASE\ORACLE_HOME\oo4o directory.


 
Oracle
Copyright © 1994, 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents

Master Index

Feedback