ORA-04091 table DPNSDL.TBLERRORLIST is mutating, trigger function may not see it ORA-04091 ORA-06512 ORA-04088

ORA-04091: table is mutating, trigger/function may not see it
ORA-04091 ORA-06512 ORA-04088


Reason:

Mutating trigger error occurs when you refer the same table in the trigger code, on which the trigger is defined..
And here, it is very clear that your Update will call the trigger, which will cause another updates, which will call the trigger....... Infinite loop..

SOLUTION

Modify your custom code to not interfere with the target table involved in the update process of the mapping.

Use procedure inspite of trigger

Use Statement level trigger inspite of rowlevel(for each row :old.testorstatus != :new.testorstatus )


Compound Trigger Solution