Re: Ora error

From: Mohamad SALEH <msaleh_at_orsys.fr>
Date: 1998/08/13
Message-ID: <35D2AA43.66E4FE90@orsys.fr>#1/1

VIDEOWAY a écrit:

> What means mutating.. ??
> what to do whit an error like that.. ?
> This error append during the execution of a database trigger
> where we insert into gcf_client.
>
> ORA-04091: table GCF.GCF_CLIENT is mutating, trigger/function may not see it

Table is mutating says that in your trigger(which is a row trigger), you try to change the table to which the trigger is associated. In the case of row triggers, only triggers with BRFORE INSERT option can "update" the associated table. Received on Thu Aug 13 1998 - 00:00:00 CDT