commit and rollback on triggers
Can we use commit and rollback statements in procedures that will be invoke by triggers?
Software/Hardware used:
oracle 10g
Software/Hardware used:
oracle 10g
ASKED:
Feb 3, 2012 11:43 AM GMT
UPDATED:
February 28, 2012 8:31:46 AM GMT
RELATED QUESTIONS
- commit and rollback on triggers
- Triggers and commitment control
- Commitment Control in RPGLE Program
- Journaling and Commitment Control
- Working TRIGGER and TRANSACTIONS QUESTION
- AS400 - DB2 concepts
- How to avoid Oracle Form to perform commit action ?
- Trigger over table that uses transaction inserts
- Searching using Oracle Forms 6i
- SQL trigger on column
Answer Wiki:
Nope.
The only way to commit or rollback in a database trigger (or a procedure/function invoked by a trigger) is using Autonomous Transactions.
The only way to commit or rollback in a database trigger (or a procedure/function invoked by a trigger) is using Autonomous Transactions.
60,245 pts.
To see other answers submitted to the Answer Wiki View Answer History.
