A

Arogya • 3.49K Points
Extraordinary

Q. While updating a table, the trigger throws ORA-04091: table is mutating. Why?

  • (A) Trigger is too large
  • (B) Trigger is querying the same table on which it is fired
  • (C) Database memory full
  • (D) Invalid cursor
  • Correct Answer - Option(B)
  • Views: 12
  • Filed under category Oracle Triggers
  • Hashtags:

Explanation by: Arogya

Mutating table error occurs when a row-level trigger tries to read or modify the same table during DML operation.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.