mutating table

From: Kader Ben <kaderb_at_yahoo.com>
Date: Wed, 27 Sep 2000 08:49:25 -0700 (PDT)
Message-Id: <10632.118013@fatcity.com>

Hi friend,

    I have created trigger (see code below) to insert some values into table. But this generate ORA-4091 error (mutating table).
Could someone suggest me a workaround?
Thank you in advance for your help.

Kader

---

CREATE OR REPLACE TRIGGER "TFIN"."TRG_WEB_ACTU_STAT" AFTER INSERT ON "TFIN"."WEB_ACTU_STAT" FOR EACH ROW declare
epoch_stat webfin_actu_stat.epoch%TYPE;
comment varchar2(20);
begin
select epoch into epoch_stat from web_actu_stat where epoch= :old.epoch;
if epoch_stat = ' ' THEN
  INSERT INTO WEB_ACTU_STAT (ID, EPOCH) VALUES (:NEW.ID, ':New.epch'); Received on Wed Sep 27 2000 - 10:49:25 CDT