The DEFINE_COLUMN_CHAR stored procedure is used to define a column at a specified position in a given cursor as CHAR type. It is used only with SELECT cursors.
Applicability
This content applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support it.
Syntax
DBMS_SQL.DEFINE_COLUMN_CHAR(c IN INTEGER,
position IN INTEGER,
column IN CHAR,
column_size IN INTEGER);
Parameters
Parameter |
Explanation |
|---|---|
| c | Defines the cursor ID of the row to be selected. |
| position | The relative position of the column in the defined row. The first column in the declaration is position 1. |
| column | The value of the defined column, whose type isCHAR. |
| column_size | The maximum value of this column, in bytes. |