| |
- Causa
- SQL CALL STATEMENT MUST SPECIFY AN OUTPUT HOST VARIABLE FOR PARAMETER number.
DB2 received an SQL CALL statement for a stored procedure.
DB2 found the row in the SYSIBM.SYSROUTINES catalog table associated with the requested procedure name.
However, parameter number was identified in the SYSIBM.SYSPARMS table as an OUT or INOUT parameter.
A host variable must be supplied on the SQL CALL statement for parameters defined as OUT or INOUT.
- number
- The parameter number from the ORDINAL field in SYSIBM.SYSPARMS.
- Ação do sistema
- The statement cannot be executed.
- Resposta ao Desenvolvedor
- If the SQL CALL statement is coded incorrectly, modify the SQL application to provide an output host variable on the SQL CALL statement.
If the SYSIBM.SYSPARMS table contains incorrect information, the DROP PROCEDURE and CREATE PROCEDURE statements must be used to replace the catalog
definition for the stored procedure.
SQLSTATE: 42886
© Copyright IBM Corp.
|
| |
