Re: Database trigger table issue.

Hi Alan,

there is a standard work around for this problem:

You have to write 2 Triggers.
The first fires AFTER ROW and write the :new.* Values in a Pipe (dbms_pipe).
The second Trigger fires AFTER STATEMENT and read out the Pipe.
In then AFTER STATEMENT Trigger you have no Problems to do your DML with the Trigger-Table.

Good luck
Walter

Alan D. Mills wrote:
>
> I have a database trigger which fires on update of all records of a specific
> table (say TABLEA). What I actually wish to do is to perform more DML on
> the same table within the trigger.
>
> I get error 4091 "Table owner.tablea is mutating". It seems I cannot
> reference tablea from anywhere within the trigger firing from it.
>
> Is there a work around for this?
>
> --
> Alan D. Mills
>
> To email remove NOSPAM from address.

--
Walter Meier (mailto:wm) Phone: 2410 Received on Thu Apr 23 1998 - 09:46:18 CDT