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 are the profiles
After deploying like forms,reports into server how we connect this forms,reports to web?
Tell me where we find the status of order information?
what is the difference between request group and request security group in oracle apps?
In which directory your flatfile is given?if u connected different instance where it is find?
what do you mean by value sets
what is the difference between multiorg views and multiorg tables
2 Answers Immense Source, Intelligroup, TCS,
what is tuning in oracle apps technical
What are Mandatory triggers to write in the block, which is created on view?
can we execute one concurrent program through another concurrent program?
How many parameters we can pass through pl/sql program in Oracle apps
in procedure how to return a value