In this blog post, let’s learn about the error message “4309 Procedure procedure-name is registered to return result sets and stored procedure result sets are not yet supported.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
4309 Procedure procedure-name is registered to return result sets and stored procedure result sets are not yet supported.
Reason for the Error
You are running an SQL/MX version that does not support stored procedure result sets and attempted to compile a CALL statement for a stored procedure that returns result sets. This message indicates that a downgrade has been performed without removing stored procedures that return result sets.
Solution
Migrate to an SQL/MX version that supports stored procedure result sets