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
