The BIND_VARIABLE_RAW stored procedure is used to bind a value of the RAW type to a variable in a 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_RAW(c IN INTEGER, name IN VARCHAR2, value IN RAW);
DBMS_SQL.BIND_VARIABLE_RAW(c IN INTEGER, name IN VARCHAR2, value IN RAW, 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 cursorRAWType 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. The binding name can include a leading colon (e.g., :X) or be omitted (e.g., X).