The BIND_VARIABLE_NUMBER procedure provides the capability
to associate a NUMBER value with an IN, INOUT, or OUT argument in
an SQL command.
Syntax
>>-DBMS_SQL.BIND_VARIABLE_NUMBER--(--c--,--name--,--value--)---><
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 DECFLOAT that specifies the value to
be assigned.
Authorization
EXECUTE privilege on the DBMS_SQL
module.
DB2 Version 9.7 for Linux, UNIX, and Windows