Home » Developer & Programmer » Forms » transactional statements in triggers
transactional statements in triggers [message #126763] Wed, 06 July 2005 09:22 Go to next message
kavitharaman
Messages: 8
Registered: June 2005
Junior Member
y commit,rollback and savepoint not allowed in triggers

kindly help me.

RK

Report message to a moderator

Re: transactional statements in triggers [message #126819 is a reply to message #126763] Wed, 06 July 2005 16:00 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
kavitharaman wrote on Wed, 06 July 2005 16:22

Why is neither commit,rollback nor savepoint allowed in triggers?


Yes it is. Use an autonomous transaction...

MHE

Report message to a moderator

Re: transactional statements in triggers [message #126846 is a reply to message #126763] Wed, 06 July 2005 22:58 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Forms triggers or database triggers?

David

Report message to a moderator

Previous Topic: modifying a view
Next Topic: Scanning of pictures through developer 6i
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 22:53:31 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.