The COLUMN_VALUE procedure returns the value of an element at the specified position in the specified cursor.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support this feature.
Syntax
DBMS_SQL.COLUMN_VALUE (c IN INTEGER,
position IN INTEGER,
value OUT NUMBER);
DBMS_SQL.COLUMN_VALUE (c IN INTEGER,
position IN INTEGER,
value OUT VARCHAR2);
DBMS_SQL.COLUMN_VALUE (c IN INTEGER,
position IN INTEGER,
value OUT DATE);
DBMS_SQL.COLUMN_VALUE (c IN INTEGER,
position IN INTEGER,
value OUT BINARY_FLOAT);
DBMS_SQL.COLUMN_VALUE (c IN INTEGER,
position IN INTEGER,
value OUT BINARY_DOUBLE);
DBMS_SQL.COLUMN_VALUE (c IN INTEGER,
position IN INTEGER,
value OUT BLOB);
DBMS_SQL.COLUMN_VALUE (c IN INTEGER,
position IN INTEGER,
value OUT RAW);
PROCEDURE COLUMN_VALUE (c IN INTEGER,
position IN INTEGER,
n_tab IN OUT NOCOPY Number_table);
PROCEDURE COLUMN_VALUE (c IN INTEGER,
position IN INTEGER,
c_tab IN OUT NOCOPY Varchar2_table);
PROCEDURE COLUMN_VALUE (c IN INTEGER,
position IN INTEGER,
d_tab IN OUT NOCOPY Date_table);
PROCEDURE COLUMN_VALUE (c IN INTEGER,
position IN INTEGER,
bl_tab IN OUT NOCOPY Blob_table);
PROCEDURE COLUMN_VALUE (c IN INTEGER,
position IN INTEGER,
cl_tab IN OUT NOCOPY Clob_table);
Parameters
| Parameter | Description |
|---|---|
| c | The ID of the cursor from which to obtain the value. |
| position | The relative position of the column in the cursor. The position of the first column in the statement declaration is 1. |
| value | The value of the specified column. |
Exceptions
If the type of the OUT parameter value is different from the actual value type, the INCONSISTENT_TYPE error is returned. When a column is defined by using the DEFINE_COLUMN statement, this type is the type specified for the column.