Re: Database trigger table issue.

From: Reinhard Bergander <reinhard_bergander_at_compuserve.com>
Date: Tue, 21 Apr 1998 23:26:32 +0100
Message-ID: <353D1D17.BDA75891@compuserve.com>

Store your values (if needed, :new, :old) in package variables. Use a After_Stmt Trigger to do more DML on the same table... (BTW you cannt use any DML on the trigger table.)

reinhard

Alan D. Mills schrieb:

> 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 - 17:26:32 CDT