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



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

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-30192: reserved for future use

1 Answers  


SQL*Loader-00305: More than one end of file character encountered

1 Answers  


PCC-02416: The Object in an OBJECT GET or SET must not be an array

1 Answers  


ORA-26535: %ud byte row cache insufficient for table with rowsize=number

1 Answers  


ORA-13609: The specified task string must be executing to be cancelled or interrupted.

1 Answers  






PLS-00662: Non-external object types containing external mapped attributes are not allowed

1 Answers  


TNS-12217: TNS:could not contact PREFERRED_CMANAGERS in TNSNAV.ORA

1 Answers  


NNL-00007: server responded with an error

1 Answers  


QSM-02018: subquery present in the WHERE clause

1 Answers  


NNO-00059: cannot construct topology checkpoint file name

1 Answers  


ORA-01271: Unable to create new file name for file string

1 Answers  


ORA-31691: The worker received message number string from the MCP, which is invalid.

1 Answers  


Categories