what is mutating table and mutating error and how to solve
that?

Answers were Sorted based on User's Feedback



what is mutating table and mutating error and how to solve that?..

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

what is mutating table and mutating error and how to solve that?..

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

what is mutating table and mutating error and how to solve that?..

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

Post New Answer

More Oracle Apps Technical Interview Questions

Is it is necessary to create P_CONC_REQUEST_ID parameter in the development of oracle apps reports

2 Answers  


How many typres of Purchase order and what are those.

2 Answers   Accenture,


What is multoorg and what is it's level or structure

4 Answers   IBM,


name at least five reports in oracle inventory related to transaction ?

3 Answers   Scan Steel,


what is meant by Table space?

2 Answers  


what are the sql attributes?

2 Answers  


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 .

1 Answers   TCS,


What do you understand by soa and what are the benefits of using this architecture?

0 Answers  


why do we go for oracle apps technical other than sap and other packages?

2 Answers  


when will formula,place holder and summary columns fire in reports?

1 Answers   TCS,


what is the defference between credit memo and debit memo

2 Answers  


In which directory your flatfile is given?if u connected different instance where it is find?

3 Answers  


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)