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');
END IF;
end;
/
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
Received on Wed Sep 27 2000 - 10:49:25 CDT