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