The BIND_VARIABLE_CHAR stored procedure is used to bind a CHAR value to a variable in the specified cursor.
Applicability
This content applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support it.
Syntax
DBMS_SQL.BIND_VARIABLE_CHAR(c IN INTEGER, name IN VARCHAR2, value IN CHAR);
DBMS_SQL.BIND_VARIABLE_CHAR(c IN INTEGER, name IN VARCHAR2, value IN CHAR, out_value_size IN INTEGER);
Parameters
Parameter |
Explanation |
|---|---|
| c | The cursor ID whose value is to be bound. |
| name | The name of the variable declared. |
| value | Variable to bind to cursorCHARType value. |
| out_value_size | OUTorIN OUTThe maximum number of bytes for the variable's return value. If not specified, usevalueThe current length of the string. |
Usage instructions
Binding variables in SQL statements are identified by name. When binding a value to a binding variable, the string that identifies the value in the statement must include a leading colon. When naming a binding variable, you can include a leading colon (for example, :X) or omit it (for example, X).