Home » SQL & PL/SQL » SQL & PL/SQL » Commit inside trigger
Commit inside trigger [message #221259] Mon, 26 February 2007 00:46 Go to next message
Messages: 6
Registered: January 2007
Junior Member
We all know, we cant use commit, rollback and save point inside the trigger directly. I would like to know why we cant use?

Re: Commit inside trigger [message #221264 is a reply to message #221259] Mon, 26 February 2007 01:04 Go to previous message
Messages: 7880
Registered: March 2000
Senior Member
Why would you want to use commit, when you are in the middle of a transaction.
Do you really want a trigger (an invisible side-effect of your DML-statement) to decide that your transaction is over, or do YOU want control over your transaction?
Previous Topic: splitting table_name and column_name from a string
Next Topic: data type problem
Goto Forum:

Current Time: Fri Aug 18 17:06:57 CDT 2017

Total time taken to generate the page: 0.36411 seconds