Wednesday 1 February 2012

ORA-04091: table string.string is mutating, trigger or function may not see it

ORA-04091: table string.string is mutating, trigger or function may not see it

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.

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

No comments:

Post a Comment