DATABASE TRIGGERS
From: <pchien_at_Trimark.com>
Date: Tue, 13 Sep 1994 18:55:37 GMT
Message-ID: <1994Sep13.185537.17699_at_trimark.com>
Date: Tue, 13 Sep 1994 18:55:37 GMT
Message-ID: <1994Sep13.185537.17699_at_trimark.com>
I have a question, base on ORACLE MANUAL say a trigger can not refer to itself (mutating table) and with this example :
create table ab (colu char (10));
create or replace trigger ab_before before insert on ab for each row
declare
wk char(10);
begin
update ab set colu = 'DD' where rownum =1;
end;
insert into ab values ('ABCD');
this should raise the exception :
ORA-04091: table PCHIEN.AA is mutating, trigger may not read or modify it
but I can successful insert the row.
can somebody tell me why ???
thankx.
-- Chao-Ping Chien, DBA Trimark Inv. Mgmt Inc. Canada pchien_at_trimark.com pchien_at_tor.hookup.netReceived on Tue Sep 13 1994 - 20:55:37 CEST