Interested to Buy Any Domain ? << Click Here >> for more details...
can we use commit in trigger? If yes how?
- 2 Answers
- 18706 Views
- Cap Gemini, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / srinivasa reddy k
Generally we cannot use commit in triggers.
But it is possible to use commit in triggers by
mentioning "pragma autonomous_transaction;" in the
declarative section of the trigger.
| Is This Answer Correct ? | 18 Yes | 3 No |
what is the difference between oracle 8i and 9i?
How to move the one file from one instance to another instance? And your scripts also?
what are the default arguments for pl/sql program?
what r the objects u have to do in u experiance
what are the receipt types in Po?
Difference between Bind and Lexical parameters?
Is it possible to do purchase order without requisition?
What is the concept of soa governance?
Exception Handilings?
Is it is necessary to create P_CONC_REQUEST_ID parameter in the development of oracle apps reports
how to call report from oracle oracle apps11i?
How to create multi-layout reports ? If we have 5 layouts , then how to get into the 4th one ?
Oracle Apps Technical 
