The BIND_VARIABLE_CHAR procedure provides the capability
to associate a CHAR value with an IN, INOUT, or OUT argument in an
SQL command.
Syntax
>>-DBMS_SQL.BIND_VARIABLE_CHAR--(--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 CHAR(254) that specifies the value to
be assigned.
- out_value_size
- An optional 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.
DB2 Version 9.7 for Linux, UNIX, and Windows