-724 THE ACTIVATION OF THE object-type OBJECT object-name WOULD EXCEED THE MAXIMUM LEVEL OF INDIRECT SQL CASCADING
Explanation
Cascading of indirect SQL occurs when a trigger, user-defined function or stored procedure invokes another trigger, user-defined function or stored procedure which in turn invokes another. The activation of some of the triggers in this chain might be due to the enforcement of referential constraint delete rules. The depth of this cascading is limited to 16.
- object-type
- Names the type of object being called. Object type is TRIGGER, FUNCTION, or PROCEDURE.
- object-name
- Specifies the name of the trigger, user-defined function or stored procedure that would have be activated at the seventeenth level of cascading.
System action
The original statement could not be executed. All SQL statements executed by all triggers, user-defined functions, and stored procedures in the cascade chain are rolled back. External actions performed by the indirect SQL, such as sending a network message might have already occurred.
Programmer response
Start with the indirect SQL that is activated by the original SQL operation. Check for recursive patterns in any invoked user-defined functions or in any triggers defined on the subject of an update operation. If the chain is not recursive, the cascade chain must be simplified by altering the triggers, user-defined functions, or stored procedures involved.
SQLSTATE
54038