Trigger procedure problem

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

Hi gurus,

Thanks for ypur replies. As suggested from most of you. To workaroud my mutating table/trigger. I create a trigger to execute a procedure that do an insert. But I run into an onther error (ORA-01403: no data found).

Thank you for your help.

SQL> create or replace procedure PROC_WEB_ACTU_STAT( x WEBFIN_ACTU_STAT.id%TYPE, y
WEB_ACTU_STAT.epoch%TYPE)
AS

BEGUIN insert into WEBFIN_ACTU_STAT(ID, EPOCH) VALUEs(x, y);
commit;
END;
/

SQL> CREATE OR REPLACE TRIGGER TRG_WEB_ACTU_STAT   BEFORE INSERT OR UPDATE ON TFIN.WEB_ACTU_STAT   FOR EACH ROW
DECLARE
    epoch_stat tfin.webfin_actu_stat.epoch%TYPE; BEGIN
  SELECT epoch INTO epoch_stat FROM TFIN.WEB_ACTU_STAT

         WHERE TFIN.WEB_ACTU_STAT.epoch = :new.epoch;   IF epoch_stat IS NULL
    THEN
       PROC_WEBFIN_ACTU_STAT(:new.id, :new.epoch);    END IF;
END; /

SQL> desc TFIN.WEB_ACTU_STAT

 Name                            Null?    Type
 ------------------------------- -------- ----
 ID                              NOT NULL NUMBER(10)
 EPOCH                           NOT NULL VARCHAR2(19)
 COMPTEUR                                 NUMBER(7)

----------------------------------------------------

SQL> insert into WEB_ACTU_STAT(ID, EPOCH) VALUES(1,
'1452');

insert into WEBFIN_ACTU_STAT(ID, EPOCH) VALUES(1,
'1452')

*
ERROR at line 1:

ORA-01403: no data found

Do You Yahoo!?
Yahoo! Photos - 35mm Quality Prints, Now Get 15 Free! Received on Wed Sep 27 2000 - 21:59:49 CDT