Re: Mutating Table in Triggers

And trap the correct exception like this:

declare

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

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 - 08:35:41 CEST