Interested to Buy Any Domain ? << Click Here >> for more details...
can we use commit in trigger? If yes how?
- 2 Answers
- 18548 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 |
how many groups we can create for query?
which parameters passed in report in oracle developer how to pass
diff between key and descriptive flexfield.
can u explain which situation automonus transaction is used
Can you define an erp system?
Explain what are the tables of auto invoice?
can we use look up type instead of a pofile option?or valueset?is it possible how?
we are inserting,update and delete the data we can do simultaniously, but it will show error in updation? what to do?
In Per_all_people_f table what is the significance of '_f ' ?
How to create a link between One dependent value set to another Dependent value set
5 Answers Indorama, ManSoft System, Syntel, TE Data,
Can you differentiate between mediator and osb?
how will you refer a report column (data column,formula,summery,placeholderr)?
Oracle Apps Technical 
