Home » SQL & PL/SQL » SQL & PL/SQL » COMMIT IN TRIGGERS
COMMIT IN TRIGGERS [message #229794] Tue, 10 April 2007 01:35 Go to next message
discoverer
Messages: 30
Registered: January 2007
Member

Can any one explain why it is not allowed to commit inside a trigger.Is there any other way to use commit inside a trigger.

Thanks & Regards ,
Pavan
Re: COMMIT IN TRIGGERS [message #229801 is a reply to message #229794] Tue, 10 April 2007 01:42 Go to previous messageGo to next message
shanthkumaar
Messages: 156
Registered: February 2007
Location: india,chennai
Senior Member

hi ,

this topic is discussed many times in the forum

check these links

link1

link2

link3

link4

link5

regards
shanth

[Updated on: Tue, 10 April 2007 01:44]

Report message to a moderator

Re: COMMIT IN TRIGGERS [message #229804 is a reply to message #229794] Tue, 10 April 2007 01:43 Go to previous message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ It is not transactional. Tell us why you want to do it and we tell you why it is absurd (except for logging purpose).
2/ Use autonomous transaction.

Regards
Michel
Previous Topic: generate and xml file
Next Topic: tune this procedure
Goto Forum:
  


Current Time: Mon Dec 05 07:14:46 CST 2016

Total time taken to generate the page: 0.05548 seconds