HPE NonStop SQL/MX Error – 4302 Procedure procedure-name expects value1 parameters but was called with value2 parameters.

In this blog post, let’s learn about the error message “4302 Procedure procedure-name expects value1 parameters but was called with value2 parameters.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

4302 Procedure procedure-name expects value1 parameters but was called with value2 parameters.

Reason for the Error

In the SQL/MX statement being compiled, a stored procedure invocation contains an incorrect number of parameters.

Solution

Correct the SQL/MX statement and retry the compilation