HPE NonStop SQL/MX Error – 1231 User-defined routine procedure-name could not be created.

In this blog post, let’s learn about the error message “1231 User-defined routine procedure-name could not be created.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

1231 User-defined routine procedure-name could not be created.

Reason for the Error

The stored procedure could not be created.

Solution

Fix the error conditions identified in messages preceding this message and reissue the CREATE PROCEDURE statement