Home » SQL & PL/SQL » SQL & PL/SQL » commit and rollback in triggers
commit and rollback in triggers [message #6778] Tue, 06 May 2003 03:50 Go to next message
Jayasri
Messages: 28
Registered: July 2000
Junior Member
Hi,
Can we have commit and rollback in triggers ?

Regards
Jayasri.
Re: commit and rollback in triggers [message #6781 is a reply to message #6778] Tue, 06 May 2003 04:22 Go to previous messageGo to next message
Barbara Boehmer
Messages: 9077
Registered: November 2002
Location: California, USA
Senior Member
As a general rule, you cannot commit or rollback within triggers. However, there is an exception to this rule, if you use PRAGMA AUTONOMOUS_TRANSACTION. However, the commit or rollback should generally be done from outside the trigger. Please click on the link below for Oracle on-line documentation on the subject:

Re: commit and rollback in triggers [message #6783 is a reply to message #6781] Tue, 06 May 2003 05:05 Go to previous message
Jayasri
Messages: 28
Registered: July 2000
Junior Member
Hi Barbara,
Thank you very much for your reply.

Regards
Jayasri.
Previous Topic: Oracle 9i Help!
Next Topic: Good OCP Exams Books
Goto Forum:
  


Current Time: Thu Mar 28 15:27:12 CDT 2024