Interested to Buy Any Domain ? << Click Here >> for more details...
can we use commit in trigger? If yes how?
- 2 Answers
- 18578 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 |
Can u suggest me the best institute for Oracle apps Technical in Hyderabad?
What is ERP? Architecture of apps?
what is the diff between custom.pll and form personalization? Tell me one example?
Write an SQL Query to Delete Duplicate records from a table using ROWID.
24 Answers pspl, Satyam, Thinkways,
Types of cursors?
How is choreography different from orchestration?
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?
Can you define an erp system?
where we find the status of order information.
what is organization id
In Oracle Apps Some tables ends with TL,VL,what is the significance of the TL and VL?
What are the different components of soa suite?
Oracle Apps Technical 
