The following Oracle external data types are supported in Oracle
functions:
- SQLT_CHR - (ORANET TYPE) character string
-
SQLT_NUM - (ORANET TYPE) oracle numeric
-
SQLT_INT
- (ORANET TYPE) integer
-
SQLT_FLT
- (ORANET TYPE) floating-point number
-
SQLT_STR
- zero-terminated string
-
SQLT_VNU
- NUM with preceding length byte
-
SQLT_PDN
- (ORANET TYPE) Packed Decimal Numeric
-
SQLT_LNG
- long
-
SQLT_VCS - variable character string
-
SQLT_NON
- null/empty PCC Descriptor entry
-
SQLT_RID
- rowid
-
SQLT_DAT
- date in Oracle format
-
SQLT_VBI
- binary in VCS format
-
SQLT_BIN
- binary data (DTYBIN)
-
SQLT_LBI
- long binary
-
SQLT_UIN
- unsigned integer
-
SQLT_SLS
- display sign leading separate
-
SQLT_LVC
- longer longs (char)
-
SQLT_LVB
- longer long binary
-
SQLT_AFC
- ANSI fixed char
-
SQLT_AVC
- ANSI Var char
-
SQLT_CUR
- cursor type
-
SQLT_LAB
- label type
-
SQLT_OSL
- oslabel type