Re: Database trigger table issue.

Been there, done that many times. The response by Wessel van Alphen is THE answer. You need to make sure your change control knows that the triggers and the package spec as one unit.

"Alan D. Mills" <alanmNOSPAM_at_uk.europe.mcd.mot.com> 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.
>
>
Received on Tue Apr 21 1998 - 20:35:04 CDT