PL/SQL: Mutating Table

From: Valentin Maier <maier_at_mailman.epnet.com>
Date: 1997/03/12
Message-ID: <3326CBC5.1172@mailman.epnet.com>#1/1

Environment: Oracle 7.3, running on an NT box.

I have an update trigger that is very simple:

CREATE OR REPLACE TRIGGER article_FNAME
AFTER UPDATE OF FNAME ON mfs.article FOR EACH ROW BEGIN
   IF (:old.FNAME IS NOT NULL) THEN

      INSERT INTO mfs.arttrans (AN,DTUPDATE,OPERINIT,UPDATETYPE,UPDATEPROCESS) 
             VALUES (:old.AN,SYSDATE,:old.PRINIT,'C','A') ;

   END IF ;
END ; When I try to update article.FNAME field, I get the error message:

ERROR at line 1:

ORA-04091: table MFS.ARTICLE is mutating, trigger/function may not see it
ORA-06512: at "MFS.ARTICLE_FNAME", line 4
ORA-04088: error during execution of trigger 'MFS.ARTICLE_FNAME'

Any idea why this happens?

TIA, Valentin. Received on Wed Mar 12 1997 - 00:00:00 CST