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