-20213 STORED PROCEDURE procedure-name HAS RETURNED A DYNAMIC RESULT SET, PARAMETER number, THAT IS NOT VALID
Explanation
A Java Stored Procedure has either returned a DYNAMIC RESULT SET parameter that is not an instance of the Java class that was used by the JDBC driver to represent a ResultSet, or it returned a DYNAMIC RESULT SET produced by a nested stored procedure.
- procedure-name
- identifies the external Java procedure whose returned parameter caused the error.
- number
- indicates the position of the parameter whose returned class was invalid.
System action
The CALL statement fails.
Programmer response
Recreate the Java method to make all returned DYNAMIC RESULT SET parameters be instances of the class produced by the DB2® Universal JDBC Driver (com/ibm/db2/jcc/t2zos/SPResultSet), and not be a DYNAMIC RESULT SET from a nested stored procedure.
SQLSTATE
46502