| |
- Causa
- SQL CALL STATEMENT SPECIFIED A NULL VALUE FOR INPUT PARAMETER number, BUT THE STORED PROCEDURE DOES NOT SUPPORT NULL VALUES.
DB2 received an SQL CALL statement for a stored procedure and found a null value in the incoming parameter list.
The stored procedure was defined in the SYSIBM.SYSROUTINES catalog table with PARAMETER_STYLE of GENERAL, which specifies that the routine does not
accept null values.
A call to a stored procedure with a LANGUAGE value of COMPJAVA receives this SQLCODE if an input parameter in the compiled Java stored procedure
has a Java base type that cannot be set to a null value.
- 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 stored procedure should not accept null values, change the calling application to provide a nonnull value.
If the stored procedure should accept null values, use the ALTER PROCEDURE statement to change the PARAMETER STYLE of the stored procedure to
be DB2SQL or GENERAL WITH NULLS.
SQLSTATE: 39004
© Copyright IBM Corp.
|
| |
