Full text search
function	OCI_obndra

Library: OCI Include: omoci.xin

Declaration

  define external counter function OCI_obndra
     (  value OCI_Handle_type cursor,
        value stream sqlvar,
        value counter sqlvl,
        value OCI_Array_type progv,
        value counter progvl,
        value counter ftype,
        value OCI_Array_type indp,
        value OCI_Array_type alen,
        value OCI_Array_type arcode,
        value counter maxsiz,
        modifiable counter cursiz
     )

This function associates an OmniMark opaque variable with a placeholder in an SQL or PL/SQL block.

Input arguments:

• cursor -- Cursor data area descriptor.
• sqlvar -- The name of the SQL placeholder, including the leading colon.
• sqlvl -- The length of the contents of sqlvar, or OCI_NTS.
• progv -- Variable used to retrieve and receive data.
• progvl -- Size of a single element in progv.
• ftype -- The external datatype of the program variable. The following values are allowed:
  • 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 character
  • SQLT_AVC -- ANSI variable character
  • SQLT_CUR -- cursor type
  • SQLT_LAB -- label type
  • SQLT_OSL -- oslabel type
• indp -- An array of indicator variables or OCI_NULL_ARRAY if not required.
• alen -- An array of element length indicators or OCI_NULL_ARRAY if not required.
• arcode -- An array of column-level error return codes or OCI_NULL_ARRAY if not required.
• maxsiz -- The maximum size of an array being bound to a PL/SQL table. For scalar and array binds use OCI_MAXSIZ_SCALAR or OCI_MAXSIZ_ARRAY.

Output argument:

• cursiz -- The actual number of elements in the array bound to a PL/SQL table. This parameter is required but ignored for scalar and array binds.

Example: