pragas urbanas online dating - Trigger updating same table oracle

trigger updating same table oracle-12trigger updating same table oracle-83trigger updating same table oracle-23

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.