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 |
Is it is necessary to create P_CONC_REQUEST_ID parameter in the development of oracle apps reports
How many typres of Purchase order and what are those.
What is multoorg and what is it's level or structure
name at least five reports in oracle inventory related to transaction ?
what is meant by Table space?
what are the sql attributes?
Hi all I am in big career dilemma. I am currently working as Oracle Apps functional consultant scm with 1 yr of exp. I am thinking to do mba. Hos it will work to di MBA in scm or operations. Please guide .
What do you understand by soa and what are the benefits of using this architecture?
why do we go for oracle apps technical other than sap and other packages?
when will formula,place holder and summary columns fire in reports?
what is the defference between credit memo and debit memo
In which directory your flatfile is given?if u connected different instance where it is find?