HPE NonStop SQL/MX Error – 3160 host variablewas declared more than once in the procedure parameter list.

In this blog post, let’s learn about the error message “3160 host variablewas declared more than once in the procedure parameter list.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

3160 host variablewas declared more than once in the procedure parameter list.

Reason for the Error

You declared host variable more than once in the procedure parameter list.

Solution

Correct the syntax and resubmit