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	1	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_BFLOAT	100	BINARY_FLOAT
ORATYPE_BDOUBLE	101	BINARY_DOUBLE
ORATYPE_CURSOR	102	PLSQL CURSOR
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_TIMESTAMP	187	TIMESTAMP
ORATYPE_TIMESTAMPTZ	188	TIMESTAMP WITH TIMEZONE
ORATYPE_INTERVALYM	189	INTERVAL YEAR TO MONTH
ORATYPE_INTERVALDS	190	INTERVAL DAY TO SECOND
ORATYPE_TIMESTAMPLTZ	232	TIMESTAMP WITH LOCAL TIME ZONE
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