Oracle Data Types and OraFlex Driver - cDbUpdateFunctionLibrary

The table show how SQL data types maps to DataFlex native types and the capacity of each type. The capacity shown is the highest possible value for the DataFlex side - or if the SQL side max value is lower - the SQL side capacity that is shown. Mostly it is the DataFlex side that has the lower capacity value.

SQL Type Name	SQL Type Constant	DataFlex Type	DataFlex Type Constant	Capacity

BLOB	eOracle_BLOB	Binary	DF_BINARY	16384
BINARY_FLOAT		Binary	DF_BINARY	16384
BINARY_DOUBLE		Binary	DF_BINARY	16384
CHAR	eOracle_CHAR	Text	DF_TEXT	2000
CLOB	eOracle_CLOB	Text	DF_TEXT	16384
DATE	eOracle_DATE	Date	DF_DATE	6.0
FLOAT	eOracle_FLOAT	Numeric	DF_BCD	14.8
INT	eOracle_INT	Numeric	DF_BCD	14.0
INTERVALDAYTOSEC	eOracle_INTERVALDS	DateTime	DF_DATETIME	23.0
INTERVALYEARTOMON	eOracle_INTERVALYM	DateTime	DF_DATETIME	23.0
LONG	eOracle_RAW	Binary	DF_BINARY	16384
LONG RAW	eOracle_LONGRAW	Binary	DF_BINARY	16384
NCHAR	eOracle_NCHAR	Text	DF_TEXT	2000
NCLOB	eOracle_NCLOB	Text	DF_TEXT	16384
NUMBER	eOracle_NUMBER	Number	DF_BCD	14.8
NVARCHAR2	eOracle_NVARCHAR2	Text	DF_TEXT	4000
RAW	eOracle_RAW	Binary	DF_BINARY	2000
ROWID	eOracle_ROWID	Text	DF_TEXT	16384
TIMESTAMP	eOracle_TIMESTAMP	DateTime	DF_DATETIME	23.0
TIMESTAMPLOCALTZ	eOracle_TIMESTAMPLTZ	DateTime	DF_DATETIME	23.0
TIMEZONETIMEZONE	eOracle_TIMESTAMPPTZ	DateTime	DF_DATETIME	23.0
UROWID		Text	DF_TEXT	16384
VARCHAR2	eOracle_VARCHAR2	Text	DF_TEXT	4000