error - ORA-4091 mutating tables
hello all
i'm getting the error ora-4091 table is mutating.
the whole scenario is like
there's a trigger on deletion of table A in which some updation is made to some other table B,
now the update trigger of table B refers the table A due to which the delete trigger of table A is giving error that
ora-4091 - table B is mutating,trigger can't see it .
can anyone help me to come out of this problem?