Mutating Table Problems with DELETE CASCADE

Overview This week, we suddenly had a "strange" error message in one of our applications: ORA-04091: table APP is mutating, trigger/function may not see it ORA-06512: at "TRG_GET_ID_APP", line 4 ORA-04088: error during execution of trigger 'TRG_GET_ID_APP'. 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.