Re: another ORA-04091 trigger problem

From: Rob Cecil <rcecil_at_my-deja.com>
Date: 2000/07/12
Message-ID: <8ki296$kgf$1@nnrp1.deja.com>#1/1

Karen <karen.abgarian_at_fmr.com> wrote:
> Rob,
>
> Given the data below you should have no problem with mutating tables
at all.
>
> Could there be another trigger on the same table?
>
> It would be helpful if you could post the error message you are
getting.
>
> Rrgs
> Karen.

Karen,

there is only one trigger on the table. This is the only trigger that has been added to the database, in fact.

Here is the error message:

ORA-04091: table KTUSER.ACTION_TRACKER is mutating, trigger/function may not see it
ORA-06512 AT "KTUSER.UPDATETRACKERHISTORY", line 2 ORA-04088: error during execution of trigger "KTUSER.UPDATETRACKERHISTORY" Do you think installing an exception handler in the trigger PL/SQL that simply swallows ORA-04091 would be advised?

Thanks for your help

Rob
rcecil_at_quoininc.com

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Jul 12 2000 - 00:00:00 CDT