Oracle 8 Data Types

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