Oracle error ORA-04091

From: sateesh <sateesh_babu_at_rediffmail.com>
Date: Thu, 16 Aug 2001 08:20:23 GMT
Message-ID: <bnLe7.620$54.15362@news1.nokia.com>

Hi,

I have written a trigger on a table, that deletes a row from another table. I am getting the error
ORA-04091: table PROVIDEO.SERVICEUNITPROFILE is mutating, trigger/function may not see it.

This is my trigger
CREATE OR REPLACE TRIGGER unit_profile_trigger   AFTER DELETE
  ON UNIT_PROFILE
  FOR EACH ROW
  BEGIN
    IF DELETING THEN
         DELETE FROM SERVICEUNITPROFILE WHERE UNITPROFILE_Id=:old.ID;     END IF;
  END; I cannot see any problem with this one as such. But definetely there is a problem.

Regards
Babu Received on Thu Aug 16 2001 - 03:20:23 CDT