Skip Headers
Oracle® Objects for OLE Developer's Guide
11g Release 2 (11.2) for Microsoft Windows

Part Number E17727-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

Type Property

Applies To

OraField Object

OraParameter Object

OraParamArray Object

Description

Returns the Variant type of the specified object. Not available at design time and read-only at run time.

Usage

data_type = orafield.Type
data_type = oraparameter.Type 
data_type = oraparamarray.Type

Data Type

Integer

Remarks

Users can expect the following mapping from Oracle internal data types:

Oracle Data Type Constant Value Data Type
BINARY_DOUBLE ORADB_DOUBLE 7 Double
BINARY_FLOAT ORADB_SINGLE 6 Single
BLOB ORADB_OBJECT 9 OraBLOB
CHAR ORADB_TEXT 10 String
CLOB ORADB_OBJECT 9 OraCLOB
DATE ORADB_DATE 8 Variant
DATE ORADB_DATE 8 Date
INTERVAL DAY TO SECOND ORADB_OBJECT 9 OraIntervalDS
INTERVAL YEAR TO MONTH ORADB_OBJECT 9 OraIntervalYM
LONG ORADB_MEMO 12 String
LONG RAW ORADB_LONGBINARY 11 String
NESTED TABLE ORADB_OBJECT 9 OraBFILE
NUMBER (1-4, 0) ORADB_INTEGER 3 Integer
NUMBER (5-9, 0) ORADB_LONG 4 Long Integer
NUMBER (10-15, 0) ORADB_DOUBLE 7 Double
NUMBER (16-38, 0) ORADB_TEXT 10 String
NUMBER (1-15, n) ORADB_DOUBLE 7 Double
NUMBER (16-38, n) ORADB_TEXT 10 String
RAW ORADB_LONGBINARY 11 String
REF ORADB_OBJECT 9 OraCollection
TIMESTAMP ORADB_OBJECT 9 OraTimeStamp
TIMESTAMP WITH LOCAL TIME ZONE ORADB_OBJECT 9 OraTimeStamp
TIMESTAMP WITH TIME ZONE ORADB_OBJECT 9 OraTimeStampTZ
VARRAY ORADB_OBJECT 9 OraCollection
VARCHAR2 ORADB_TEXT 10 String

These values are located in the ORACLE_BASE\\ORACLE_HOME\oo4o\oraconst.txt file and are intended to match similar constants in the Visual Basic file datacons.txt file.

Note that fields of type DATE are returned in the default Visual Basic format as specified in the Control Panel, even though the default Oracle date format is "DD-MMM-YY".

Note that columns defined as NUMBER instead of NUMBER(precision, scale) are, by definition, floating point numbers with a precision of 38. This means that the Type property returns a type of ORADB_TEXT for these columns.

See Also:

Value Property