The DESCRIBE_COLUMNS2 stored procedure is used to retrieve the attribute information of all columns for a cursor, such as column names and types. The description is returned in a table of type DESC_TAB2.
Applicability
This content applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support it.
Syntax
DBMS_SQL.DESCRIBE_COLUMNS2(c IN INTEGER,
col_cnt OUT INTEGER,
desc_t OUT DESC_TAB2);
Parameters
Parameter |
Explanation |
|---|---|
| c | Cursor ID. |
| col_cnt | The number of columns selected in the query. |
| desc_t | Describes each column of the table. The type isDESC_TAB2. |