can we use commit in trigger? If yes how?
- 2 Answers
- 17184 Views
- Cap Gemini, TCS, I also Faced
- E-Mail Answers
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
Can you explain the difference between architecture followed in 10g & 11g?
What do you understand by soa?
how can i print random rows in plsql table
Can you differentiate between mediator and osb?
testing tools?
What are the different components of soa suite?
List the types of flexfield?
How to create a purchase order without a requisition?
how do you describe O2C along with tables
Tell me how to find the custom directory in front end?
What do you understand by concurrent programs?
Explain what are the tables of auto invoice?
what is pay run id ?
what is global tempory table?
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
