Full text search
function	OCI_odescr

Library: OCI Include: omoci.xin

Returns: Numeric Returns OCI_SUCCESS if the function completes without error.

Declaration

  define external counter function OCI_odescr
     (  value OCI_Handle_type cursor,
        value counter pos,
        modifiable counter dbsize,
        modifiable counter dbtype,
        modifiable stream cbuf,
        modifiable counter cbufl,
        modifiable counter dsize,
        modifiable counter prec,
        modifiable counter scale,
        modifiable counter nullok
     )

This function describes select-list items for SQL queries. The function returns internal datatype and size information for a specified select-list item.

Input aruguments:

• cursor -- Cursor data area descriptor.
• pos -- The index position of the data column in the row. The first column is position 1.

Output arguments:

• dbsize -- The maximum size of the column.
• dbtype -- The internal datatype of the select-list item.
• cbuf -- The name of the select-list item.
• dsize -- The maximum display size of a character string select-list item.
• prec -- The precision of numeric select-list items.
• nullok -- Returns OCI_NULLABLE if null values are permitted in the column.

Input/output argument:

• cbufl - The maximum name length, on input, and the returned length of the item name on return.

Example: