Re: Commit fired by trigger

From: <karsten_schmidt8891_at_my-deja.com>
Date: Fri, 19 Nov 1999 09:34:59 GMT
Message-ID: <8135k3$b3m$1@nnrp1.deja.com>

Hi,

you may be able to get away using autonomous transactions. as tom kyte pointed out, it is not allowed to commit the transaction that fired your trigger - you may be able to commit 'independend' transactions, say for auditing purposes.

never tried it myself though.

Karsten

In article <8118ri$kf0$1_at_autumn.news.rcn.net>, "Alan Shein" <alanshein_at_erols.com> wrote:
> You can't issue any transaction control statements (such as COMMIT)
from a
> trigger.
>
> Pietro Albrizio <palbrizioNOpaSPAM_at_delos.it.invalid> wrote in message
> news:2ebc88ec.75906623_at_usw-ex0110-073.remarq.com...
> > Hi all,
> > how can i fire a commit with a trigger.
> > The trigger contains the command commit.
> > Thanks in advance.
> >
> >
> > * Sent from AltaVista http://www.altavista.com Where you can also
find
> related Web Pages, Images, Audios, Videos, News, and Shopping. Smart
is
> Beautiful
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Nov 19 1999 - 03:34:59 CST