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 |
How to call oracle database stored procedure from form in form coding ?
testing tools?
0 Answers BirlaSoft, Convergys,
what is user exit and wat program do we write in user exit?
How to create user and how u attach with responsibility.
When you run he report you have to get only that particular organization po numbers or item number how can do it?
What is Formula Column?
what are version control tools used in oracle apps?
Difference between set of books id and ledger id in r12 ?
In interface how u find errors and how to solve. How to fix it?
Is it possible calling from one report to another? if possible means tell me ?
3 Answers Intelligroup, Satyam,
What should be the batch size (number of customer records) general guidelines for optimal performance?
what is multi org structure?