The DESCRIBE_COLUMNS3 stored procedure is used to retrieve the attribute information of all columns for a cursor, such as column names and types. The descriptive information is returned in a table of type DESC_TAB3.
Applicability
This content applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support it.
Syntax
DBMS_SQL.DESCRIBE_COLUMNS3(c IN INTEGER,
col_cnt OUT INTEGER,
desc_t OUT DESC_TAB3);
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_TAB3. |