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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a value set? List its various types.

648


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

617


can we use look up type instead of a pofile option?or valueset?is it possible how?

1779


what is the differences between internal requisition and internal sales order?

2151


Do you know what is applysys in oracle application database schema, what is apps?

668






what are the different transaction clauses in AR?

1598


Hi  Friends this is preetham, i am  searching for job on oracle apps(technical) i put 3 years fake exp, so any one  please could you help me for realtime interview  questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify

1563


How can a process be deployed in soa?

690


How to move the one file from one instance to another instance? And your scripts also?

607


CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

2084


Can you explain the difference between architecture followed in 10g & 11g?

652


what is the difference between request group and request security in oracle apps?

5036


In hierarchical structure of a database? we have write query from where we should start?

1699


What is oracle soa suite and what are its different components?

639


In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.

2456