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
SQLT_CLOB - Character LOB
SQLT_BLOB - Binary LOB
SQLT_BFILEE - Binary File LOB
SQLT_CFILEE - Character File LOB
SQLT_RSET - Result Set