Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> 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
![]() |
![]() |