HPE NonStop SQL/MX Error – 11062 Procedure with OUT or INOUT parameters are not supported in trigger action statement.

In this blog post, let’s learn about the error message “11062 Procedure with OUT or INOUT parameters are not supported in trigger action statement.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

11062 Procedure with OUT or INOUT parameters are not supported in trigger action statement.

Reason for the Error

The trigger action of the CREATE TRIGGER statement includes a stored procedure using OUT or INOUT parameters.

Solution

Rewrite the trigger to use stored procedures with only IN parameters in the trigger action