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
what are the different transaction clauses in AR?
what is the differences between internal requisition and internal sales order?
pls send me out bound code of supplers,site,bankiformation code pls as soon as
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?
Explain what are the tables of auto invoice?
tell my any difficult situtation you solved in your experience in your company?
tell me the scenarios of the independent in reports
How can you achieve loose coupling in soa framework?
Plz anybody send me Technical specification for AP Interface
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
How can a process be deployed in soa?
In oracle application how do you debug or trace errors?
WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?
What do you understand by soa?
Do you know where we can check the status of po?