what is mutating table and mutating error and how to solve
that?
Answers were Sorted based on User's Feedback
Answer / kranthi kumar
A table which is under process of update,delete or insert
is a mutating table.
when you try to perform an action such as insert,update or
delete on that same table using a trigger then mutating
table error occurs.
if u want to solve this error then use autonomous
transaction.
| Is This Answer Correct ? | 12 Yes | 1 No |
Answer / saji. sasidharan
Mutating table is the table which is being in the process
of UPDATE,DELETE or INSERT. Mutating error will happen if
try to access a mutating table. Example. Its possible to
solve using autonamous transaction.
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / vijay
In row level trigger based on table, the trigger body can not read the same table data, if we try to read the same table data then we get error.
This error is called mutating error.
These table is called as mutating error.
| Is This Answer Correct ? | 0 Yes | 0 No |
WHAT IS THE FORWARDREFERENCE IN PL/SQL?
WHAT IS THE USE OF SKIP WHERE U WILL GIVE?
In interface process we have 1000 records i want to commit every 100 records how? How i can commit every 100 records?
why do we go for oracle apps technical other than sap and other packages?
in which tables the transaction details stored? at least two.
How many schemas we have? how many you have used?
What is set function in sql .E.g.What is difference between union and union all
We have to show a logo/image in a report? what are the steps and which format it is?whether in pdf format is applicable or not?
Steps for DFF registration
in ap_terms table what data will be stored
where the accounting related data is stored ?
In which table or database definition we can find the link of organization and operation units.