HPE NonStop SQL/MX Error – 11236 Stored procedure procedure-name attempted to return too many result sets. The maximum number of result sets this procedure can return is max-results, and the procedure body attempted to return attempted-results.

In this blog post, let’s learn about the error message “11236 Stored procedure procedure-name attempted to return too many result sets. The maximum number of result sets this procedure can return is max-results, and the procedure body attempted to return attempted-results.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

11236 Stored procedure procedure-name attempted to return too many result sets. The maximum number of result sets this procedure can return is max-results, and the procedure body attempted to return attempted-results.

Reason for the Error

During the execution of a CALL statement, the number of result sets returned from an SPJ method exceeds the procedure’s declared maximum. The declared maximum was specified in the DYNAMIC RESULT SETS clause of the CREATE PROCEDURE statement.

Solution

None. This message is issued as a warning. If desired, change the SPJ method to return fewer result sets, or recreate the procedure with a higher value for DYNAMIC RESULT SETS