The VARIABLE_VALUE_CHAR stored procedure is used to retrieve the value of an output variable of type CHAR after executing a dynamic SQL statement.
Applicability
This content applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support it.
Syntax
DBMS_SQL.VARIABLE_VALUE_CHAR(c IN INTEGER, name IN VARCHAR2, value OUT CHAR);
Parameters
Parameter |
Explanation |
|---|---|
| c | The ID of the dynamic SQL cursor that has been opened. |
| name | The name of the variable to be retrieved. |
| value | The target variable for storing the return value, of typeCHAR. |