vantive
asked on
ORA-04091 - Mutation
ORA-04091 - Mutation. Please, I want to make a trigger that update on cascade but this generates the error. Please try to solve this problem using a TRIGGER. OBS: I'm using AFTER UPDATE event.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The only solution that we have found for this is to implement the constraint as part of the trigger, thus:
1) Drop the constraint (normally some time of foreign key)
2) Add the code to the trigger(s) that implements the constraint:
If, for example, it is a foreign key ON CASCADE DELETE relationship, then you will have to delete the child records in a BEFORE DELETE trigger on the parent record, etc.
If this is more helpful than konektor's comments, then please reject his answer and I can post some sample code in a more complete answer of my own.
If this is not the problem, then it might be that you are doing a TABLE update while some of the individual ROWS are in transition. In this case you should try to modify your trigger so that it is an AFTER UPDATE ON ROW trigger.