The COLUMN_VALUE stored procedure returns the cursor element of a specified column in a specified cursor.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
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 to which the value belongs. |
| position | The relative position of the target column in the cursor. This value starts at 1. |
| value | The value of the specified column. |
Exceptions
If the type of the output parameter value is different from the actual type of the value, an INCONSISTENT_TYPE exception will be thrown. If the column was defined by calling the DEFINE_COLUMN procedure, this type is the type specified in the call.