Interested to Buy Any Domain ? << Click Here >> for more details...
what is mutating table and mutating error and how to solve
that?
- 3 Answers
- 11973 Views
- I also Faced
- E-Mail Answers
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 pass data into EXECUTE_IMMEDIATE statement in plsql body ?
how many sections are there in report?
Need Training & Internship with guaranteed Job in ERP - Oracle Apps Tech?
What is the interface?
What are the validations you don in .CTL file in inbound interface process?
What are the User PARAMETERS in the Reports?
I Have report which is having field at the end of page,,, problem is when i run report data is overflowing to the next page,,i want the data to come on same page can anybody help me out????
How will you get the concurrent program output as email?
How to develop XML report without rdf?
How do you register report in oracle apps?
Where I can download D2K software?
where to define interorganization transaction charges and what are the different options?
Oracle Apps Technical 
