HPE NonStop SQL/MX Error – 13031 Expecting a single host variable of type string.

In this blog post, let’s learn about the error message “13031 Expecting a single host variable of type string.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

13031 Expecting a single host variable of type string.

Reason for the Error

You attempted to execute a PREPARE or EXECUTE IMMEDIATE statement. The preprocessor found one of these errors:

You did not specify more than one host variable of this type.

The host variable that you specified is not character type STRING.

Solution

Correct the host variable and resubmit