can we use commit in trigger? If yes how?
- 2 Answers
- 17555 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 |
why r u transer the data base tables to flat file and what is use
do you know is it possible to run the interface without using oracle apps?
What are the requests groups?
which parameters passed in report in oracle developer how to pass
A file has both header and corresponding lines. Explain design to load this data into respective interface tables.
What r the validation types?
what are the difference between 11.5.7 and 11.5.9 in oracle apps
what do you mean by value sets
IN WHICH MODULE THE LEGAL ENTITY COMES?
what is aim methodolozy
How do u identity its name of report?
how will you refer a report column (data column,formula,summery,placeholderr)?
Oracle Apps Technical 
