-729   A STORED PROCEDURE SPECIFYING COMMIT ON RETURN CANNOT BE THE TARGET OF A NESTED CALL STATEMENT

Explanation

A stored procedure defined with the COMMIT ON RETURN attribute was called from a stored procedure, user-defined function, or trigger. Stored procedures defined with COMMIT ON RETURN cannot be nested in this way.

System action

The SQL statement is not executed. If the CALL statement references a remote server, the unit of work is placed in a must rollback state.

Programmer response

Remove the CALL to the stored procedure that was defined with the COMMIT ON RETURN attribute.

SQLSTATE

429B1