Re: Mutating Table in Triggers

From: Ole C Meldahl <meldahl_at_pvv.org>
Date: Thu, 06 May 1999 08:35:41 +0200
Message-ID: <3731383D.F45E757F@pvv.org>

And trap the correct exception like this:

declare

       tbl_Mutating EXCEPTION;
       PRAGMA EXCEPTION_INIT(tbl_Mutating, -04091);

begin
.....

exception
 WHEN tbl_Mutating THEN

    NULL; /* Ok, checking done elsewhere */ end;

ole c

Al Ruiz wrote:

> Try adding an exception handler in your trigger
> e.g.
> .
> begin
> ...
> exception
> when others
> ...
> end
>
> > >yitbsal_at_statcan.ca wrote in message <7egb6j$j88$1_at_nnrp1.dejanews.com>...

> > >>In the trigger, is there a way to check whether table B is mutating. This

> > >way,
> > >>I can run the update code only if table B is not mutating.
> > >>
> > >>Thanks,
> > >>Salaam Yitbarek
> > >>
Received on Thu May 06 1999 - 01:35:41 CDT