ServerType Property
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 data types 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.
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_LONG
| 8
| LONG
|
ORATYPE_VARCHAR
| 9
| VARCHAR
|
ORATYPE_DATE
| 12
| DATE
|
ORATYPE_RAW
| 23
| RAW
|
ORATYPE_LONGRAW
| 24
| LONG RAW
|
ORATYPE_UINT
| 68
| UNSIGNED INTEGER
|
ORATYPE_CHAR
| 96
| CHAR
|
ORATYPE_CHARZ
| 97
| Null Terminated CHAR
|
ORATYPE_MLSLABEL
| 106
| 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
|
These values can be found in the file ORACONST.TXT.
Data Type
Integer