In this blog post, let’s learn about the error message “4304 Host variable or dynamic parameter parameter-name is used in more than one OUT or INOUT parameter for routine routine-name. Results may be unpredictable.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
4304 Host variable or dynamic parameter parameter-name is used in more than one OUT or INOUT parameter for routine routine-name. Results may be unpredictable.
Reason for the Error
In the SQL/MX statement being compiled, you attempted to invoke a stored procedure that contains the same host variable or dynamic parameter in more than one OUT or INOUT parameter.
Solution
Use different host variables for each of the OUT or INOUT parameters
