In this blog post, let’s learn about the error message “11237 Stored procedure procedure-name attempted to return result sets but the JDBC/MX driver in the SPJ environment does not support stored procedure result sets.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
11237 Stored procedure procedure-name attempted to return result sets but the JDBC/MX driver in the SPJ environment does not support stored procedure result sets.
Reason for the Error
During the execution of a CALL statement, an SPJ method returned result sets but the result sets could not be processed because the version of JDBC/MX in the SPJ environment does not support stored procedure result sets.
Solution
Change the version of JDBC/MX in the SPJ environment to one that supports stored procedure result sets
