Contents
What is mutating in the trigger Please select all the correct answers?
Mutating trigger is trigger that is currently being modified by DML opertion.
- sabrishandyou. Answered On : Jan 26th, 2010.
- There are cases when we have mutating table error inspite of using an “AFTER TRIGGER at ROW LEVEL”. This happens when you are using an after delete trigger.
What is mutating table?
A mutating table is a table that is currently being modified by an UPDATE, DELETE, or INSERT statement, or it is a table that might need to be updated by the effects of a declarative DELETE CASCADE referential integrity constraint.
Is mutating a trigger function?
Mutating Tables Mutating table errors only impact row level triggers. But to use a statement level trigger, some data may need to be preserved from each row, to be used by the statement level trigger. On delete triggers have no :NEW values. Triggers do not commit transactions.
Why commit is not used in triggers?
Not only do triggers not need a COMMIT you can’t put one in: a trigger won’t compile if the body’s code includes a COMMIT (or a rollback). This is because triggers fire during a transaction. When the trigger fires the current transaction is still not complete.
Is the table in ora-04091 mutating?
ORA-04091: table is mutating, trigger/function may not see – Ask TOM Thanks for the question, Subhash. Viewed 50K+ times! This question is I am getting “ORA-04091: table is mutating, trigger/function may not see it” in my trigger.
How to resolve ora-04091 trigger may not see it?
I am getting “ORA-04091: table is mutating, trigger/function may not see it” in my trigger. Trigger is created. Please let me know how to resolve this. and we said… You can’t query the table that caused a trigger to fire inside the trigger itself. But in this case, I don’t see any need to.
When is trigger / function may not see it?
ORA-04091: table SYSTEM2.DETAILRENTAL is mutating, trigger/function may not see it ORA-06512: at “SYSTEM2.TRG_VIDEORENTAL_UP”, line 3 ORA-04088: error during execution of trigger ‘SYSTEM2.TRG_VIDEORENTAL_UP’ 1. UPDATE DETAILRENTAL 2. SET DETAIL_RETURNDATE = null 3. WHERE RENT_NUM = 1006 AND VID_NUM = 61367
What is the purpose of trigger in SQL?
The purpose of trigger is to fire automatically when table is updated, inserted or deleted in your case. What you need is some procedure, not trigger. use this statement inside DECLARE, it will work. I had the same issue and I noticed that if you do a select on the same table you put the trigger on you may/will get this problem.