can we use commit in trigger? If yes how?

Answer Posted / prasad reddy

Yes ,You can Commit inside the trigger.

But for this you have to make this trigger transaction to be
a Independent transaction from its parent transaction, You
can do this by using Pragma. Pragma AUTONOMOUS_TRANSACTION
allow you to build the Indepadent(child) Transaction,started
by another

Cheers
-Prasad

Is This Answer Correct ?    21 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the different transaction clauses in AR?

1598


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

2151


pls send me out bound code of supplers,site,bankiformation code pls as soon as

1750


List of all the modules under Manufacturing, Finance and Distribution in oracle applications?

1797


Explain what are the tables of auto invoice?

640






tell my any difficult situtation you solved in your experience in your company?

1866


tell me the scenarios of the independent in reports

2043


How can you achieve loose coupling in soa framework?

715


Plz anybody send me Technical specification for AP Interface

2006


please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in

3074


How can a process be deployed in soa?

692


In oracle application how do you debug or trace errors?

631


WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?

2587


What do you understand by soa?

687


Do you know where we can check the status of po?

629