Interested to Buy Any Domain ? << Click Here >> for more details...
can we use commit in trigger? If yes how?
- 2 Answers
- 18699 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 meant by boilerplates?
How do u customize the Reports?
how can we return morethan one parameters in procedure?
How can you achieve loose coupling in soa framework?
in order to run utl_file package we need to give any specific path? if yes what is that?where u will run utl_package?
Give a overview on Aol
What is implicity cursor . When it fires . For which statement it will fire(Insert/update/delte). What is the attribute of implicity and explicity cursor oracle 9i. What is the Rec cursor.
What is procedure?
what is meant by Drill Down in Discoverer report? why it will be use?
in oracle workflow if i want to send a mail to the user after sending if the user didn't approve the mail after 10 mins it is automatimatically approved how we can approach?
What is the link between AP and GL in oracle apps R/12?
4 Answers Bosch, Collabera, Synechron,
what is the invoice matching
Oracle Apps Technical 
