Mutating problem

From: philippe <philippe_at_arpege.imaginet.fr>
Date: Fri, 17 Apr 1998 10:48:54 +0200
Message-ID: <35371776.F14204B3@arpege.imaginet.fr>

With the following shema, i got a mutating table problem each time I try to modify the
SUIVI column of dossier. So I dropped the constraint on the SUIVI table and it works. It does not satisfy me anyway. What is the problem and how can I solve it ??

create table DOSSIER (

               NODOSSIER NUMBER(38) PRIMARY KEY,
               SUIVI VARCHAR(20),
               ...)

create table SUIVI (
               NODOSSIER NUMBER(38),
               SUIVI      VARCHAR(20),
               DATE_DEB_SUIVI NUMBER(38),
               DATE_FIN_SUIVI NUMBER(38),
               CONSTRAINT FK_Suivi FOREIGN KEY  (NODOSSIER) REFERENCES

DOSSIER(NODOSSIER) ON DELETE CASCADE
);

CREATE OR REPLACE TRIGGER TRG_DOSSIER
   AFTER UPDATE OF SUIVI ON DOSSIER
   FOR EACH ROW
   BEGIN
       INSERT INTO SUIVI VALUES (:new.NODOSSIER, :old.SUIVI, :old.DATE_DEB_SUIVI, :old.DATE_FIN_SUIVI);

END IF;
END; Received on Fri Apr 17 1998 - 03:48:54 CDT