HPE NonStop SQL/MX Error – 4307 Rowset parameters are not allowed in a CALL statement.

In this blog post, let’s learn about the error message “4307 Rowset parameters are not allowed in a CALL statement.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

4307 Rowset parameters are not allowed in a CALL statement.

Reason for the Error

In the SQL/MX statement being compiled, you attempted to use a rowset as a parameter in a stored procedure invocation.

Solution

Alter the data type of the relevant variable, or use a different nonrowset host variable. Retry the compilation