pragas urbanas online dating - Trigger updating same table oracle
Here we get correct result without getting mutating table error.
This is also one very good advantage of compound triggers.
AM27_TRG", line 4 ORA-04088: error during execution of trigger 'SYSTEM.
AM27_TRG' In the above example, as table AM27 is being queried in the trigger AM27_TRG that is based on the same table, a mutating error is received.
Most of us who have worked in Oracle have encountered ORA-04091 (table xxx is mutating.