OraFAQ Forum: Training & Certification » how to use commit statement inside a trigger

Home » Other » Training & Certification » how to use commit statement inside a trigger

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to use commit statement inside a trigger [message #298624]

Wed, 06 February 2008 19:31

ryuva4u
Messages: 2
Registered: February 2008

Junior Member

how to use commit while executing a trigger?

Report message to a moderator

Re: how to use commit statement inside a trigger [message #298626 is a reply to message #298624]

Wed, 06 February 2008 19:35

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Did you search the forum?

By
Vamsi

Report message to a moderator

Re: how to use commit statement inside a trigger [message #298651 is a reply to message #298624]

Thu, 07 February 2008 00:22

Michel Cadot
Messages: 68643
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You don't commit inside a trigger.

Regards
Michel

Report message to a moderator

Re: how to use commit statement inside a trigger [message #298660 is a reply to message #298624]

Thu, 07 February 2008 00:59

raj1222
Messages: 5
Registered: February 2008
Location: hyd

Junior Member

hai,

In triggers we dont use any transactional control statements.

commit,rollback will not work in triggers.

Report message to a moderator

Re: how to use commit statement inside a trigger [message #298666 is a reply to message #298660]

Thu, 07 February 2008 01:19

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

There are cases when committing in a trigger is justified. For example, error logging is one of these cases. Scenario: user performs an illegal operation which is to be rolled back. Autonomous transaction trigger will save (commit) error information into the error log table, whilst the main transaction data is rolled back.

Here's an example (a screenshot, to emphasize different sessions):

/forum/fa/3867/0/

Attachment: trg_aut_trans.PNG
(Size: 22.50KB, Downloaded 1860 times)

Report message to a moderator

Re: how to use commit statement inside a trigger [message #298714 is a reply to message #298666]

Thu, 07 February 2008 05:01

Frank
Messages: 7901
Registered: March 2000

Senior Member

Technically, the question is whether the commit is still 'in the trigger', as you start a new autonomous transaction.

btw, your password is showing in the screenshots (title-bar)

Report message to a moderator