Stack Overflow
Stack Overflow

Questions tagged [mutating-table]

Mutating table errors generally happen when a trigger tries to reference/modify the same table on which trigger is firing on.

Mutating table/trigger errors are mostly caused when you try to reference/modifies the table on which the trigger is firing.

The error generally refers to a flaw in application logic or data model.

APC explains the data model flaw:

Some highly viewed questions/solutions on this

64 questions
-1
votes
1 answer

In which trigger error occured -oracle mutating error

In live environment there is a screen which is used to authorize the transaction, during the authorisation, data will be update in the table T1. This screen working with no issue, suddenly user told there is an error is throwing during…
Prog_2918
  • 19
  • 8
-1
votes
1 answer

Oracle SQL mutating table trigger before update

I want to create an update trigger for a table. The trigger was created, but when I update the column finish, it say mutating table. This is my code CREATE OR REPLACE TRIGGER SET_COST BEFORE UPDATE OF finish ON PAY FOR EACH ROW BEGIN …
Hilfit19
  • 29
  • 7
-1
votes
1 answer

Removal of mutating trigger

I am trying to create a trigger which counts the date of a service and the ID of a branch. The objective of the trigger is to count the number of branch ID as well as the date of service. If the count is greater than 3 then the trigger should come…
user3010257
  • 11
  • 4
-3
votes
1 answer

How to solve a mutant trigger

I AM NEW IN PL / SQL ORACLE I HAVE A PROBLEM, TO MAKE A TRIGGER FOR A MUTATING TABLE I WANT TO REALIZE THE FOLLOWING: BY INSERTING AN ORDER, ON THE ORDER_ITEMS TABLE, THE ORDERED AMOUNT (QUANTITY) IS RESTED IN THE INVENTORY OF THE TABLE INVENTORIES…
Tony Maldonado
  • 1
1 2 3 4
5