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

ServerType Property

See Also
Example

Applies To

OraParameter

OraParamArray

Description

Specifies the Oracle external type of SQL or PL/SQL bind variable. Not available at design time and read/write at run time.

Read only for the OraParamArray object. (You specify ServerType during the AddTable method.)

Usage

oraparameter.ServerType = oracle_type

Remarks

Used to specify the external data type of SQL or PL/SQL (in/out) bind variables. This is necessary since no local parsing of the SQL statement or PL/SQL block is done to match the datatypes of placeholders in the SQL statement or PL/SQL block.

After an OraParameter has been set to ServerType BLOB, CLOB, BFILE, OBJECT, REF, VARRAY, or NESTED TABLE, it cannot be changed to any other ServerType.

The following Oracle external datatypes are supported.

Oracle External Datatypes Supported

Constant
Value
Internal DataType
ORATYPE_VARCHAR2

VARCHAR2
ORATYPE_NUMBER
2
NUMBER
ORATYPE_SINT
3
SIGNED INTEGER
ORATYPE_FLOAT
4
FLOAT
ORATYPE_STRING
5
Null Terminated STRING
ORATYPE_VARCHAR
9
VARCHAR
ORATYPE_DATE
12
DATE
ORATYPE_UINT
68
UNSIGNED INTEGER
ORATYPE_RAW
95
RAW
ORATYPE_CHAR
96
CHAR
ORATYPE_CHARZ
97
Null Terminated CHAR
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_VARRAY
247
VARRAY
ORATYPE_TABLE
248
NESTED TABLE
ORATYPE_RAW_BIN
2000
RAW

These values can be found in the file ORACLE_BASE\ORACLE_HOME\oo4o\oraconst.txt.

Data Type

Integer


 
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