The error ORA-04091:table My_READER.EMP_DEPT is mutating, comes when

Options
- A trigger query the table being deleted
- A trigger query the table being truncated
- A trigger query the table being dropped
- A trigger query the table being modified

CORRECT ANSWER : A trigger query the table being modified

Discussion Board
Error ORA-04091

The error "ORA-04091:table My_READER.EMP_DEPT is mutating" comes when the table is being modified. A statement executed a trigger or custom PL/SQL function. That trigger/function tried to modify or query a table that is currently being modified by the statement that fired the trigger/function. To resolve this Oracle error re-write the trigger/function so that it does not try to modify/query the table in question.

Prajakta Pandit 02-22-2017 06:32 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Related Content

Advertisement
 
▲