Type (OraAttribute) Property

Applies To

OraAttribute Object

Description

A integer code representing the Server type of this attribute.

Usage

typecode = OraAttribute.Type

Remarks

These integer codes correspond to external data types in OCI8. The codes are:

ORATYPE_VARCHAR2

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
These codes are also listed in the ORACONST.TXT file located in the ORACLE_HOME\OO4O directory.

Data Type

Integer