HPE NonStop SQL/MX Error – 3208 UNSIGNED numeric is not allowed for routine parameter.

In this blog post, let’s learn about the error message “3208 UNSIGNED numeric is not allowed for routine parameter.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

3208 UNSIGNED numeric is not allowed for routine parameter.

Reason for the Error

In the CREATE PROCEDURE statement, one of the parameters you specified is an unsigned numeric.

Solution

Change the parameter specification to SIGNED