Oracle database error code ORA-04091 – table string.string is mutating, trigger/function may not see it

Oracle Database Error Code ORA-4091 Description :
table string.string is mutating, trigger/function may not see it
Error Cause:
A trigger (or a user defined plsql function that is referenced in this statement) attempted to look at (or modify) a table that was in the middle of being modified by the statement which fired it.

How to Solve :
Rewrite the trigger (or function) so it does not read that table.


Filed under: How to Solve, Oracle 10g, Oracle 11g, Oracle 9i, Oracle Error Codes     Etiketler:, , , , , , , , , , , , , ,
No Comment Yet   
«
»