HPE NonStop SQL/MX Error – 2068 A procedure body must be a SELECT, INSERT, UPDATE, DELETE, MERGE, DECLARE CATALOG, DECLARE SCHEMA, or a static DECLARE CURSOR.

In this blog post, let’s learn about the error message “2068 A procedure body must be a SELECT, INSERT, UPDATE, DELETE, MERGE, DECLARE CATALOG, DECLARE SCHEMA, or a static DECLARE CURSOR.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

2068 A procedure body must be a SELECT, INSERT, UPDATE, DELETE, MERGE, DECLARE CATALOG, DECLARE SCHEMA, or a static DECLARE CURSOR.

Reason for the Error

You specified a procedure whose body is invalid. It must be a SELECT, INSERT, UPDATE, DELETE, MERGE, DECLARE CATALOG, DECLARE SCHEMA, or static DECLARE CURSOR.

Solution

Correct the syntax and resubmit