BIND_VARIABLE_VARCHAR procedure - Bind a VARCHAR value to a variable

The BIND_VARIABLE_VARCHAR procedure provides the capability to associate a VARCHAR value with an IN, INOUT, or OUT argument in an SQL command.

Syntax

Read syntax diagramSkip visual syntax diagramDBMS_SQL.BIND_VARIABLE_VARCHAR( c,name,value ,out_value_size)

Parameters

c
An input argument of type INTEGER that specifies the cursor ID for the SQL command with bind variables.
name
An input argument of type VARCHAR(128) that specifies the name of the bind variable in the SQL command.
value
An input argument of type VARCHAR(32672) that specifies the value to be assigned.
out_value_size
An input argument of type INTEGER that specifies the length limit for the IN or INOUT argument, and the maximum length of the output value for the INOUT or OUT argument. If it is not specified, the length of value is assumed.

Authorization

EXECUTE privilege on the DBMS_SQL module.