Top "Mutating-table" questions

Mutating table errors generally happen when a trigger tries to reference/modify the same table on which trigger is firing on.

Oracle Form FRM-40735: ON-ERROR trigger raised unhandled exception ORA-06502

I have a table trigger like below: CREATE OR REPLACE TRIGGER PAT_BUR_DOB_TRG BEFORE UPDATE OF DOB ON …

oracle plsql triggers oracleforms mutating-table
INSERT trigger for inserting record in same table

I have a trigger that is fire on inserting a new record in table in that i want to insert …

oracle triggers insert mutating-table
How Can I code a "IF UPDATING" trigger in Oracle Database 10g?

I'm coding a Trigger to ensure only one type of money can be set as official. My intention is code …

oracle plsql triggers dml mutating-table
ORACLE After update trigger: solving ORA-04091 mutating table error

I am trying to create a trigger: create or replace trigger NAME_OF_TRIGGER after insert or update on table1 …

sql oracle plsql triggers mutating-table
ORA-04091: table SCMA.XX is mutating, trigger/function may not see it

I have two tables- XX and YY with their triggers calling each other in case of an update. The trigger …

oracle plsql triggers oracle11gr2 mutating-table