Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> quick question about after statement triggers

quick question about after statement triggers

From: Jack Addington <jaddington_at_shaw.ca>
Date: Mon, 17 Oct 2005 17:54:41 GMT
Message-ID: <BzR4f.214248$oW2.22807@pd7tw1no>


If I have an after statement trigger defined as

cREATE OR REPLACE TRIGGER some_table_aius after INSERT or update
on some_table
declare

begin

    do_some_process( xxx );

end;

and then I do:

insert into some_Table(...)
insert into some_table (...)
update some_table set xxx where yyy

commit;

will the do_some_process function fire twice, once for updates and once for inserts or just once?

thx

jack Received on Mon Oct 17 2005 - 12:54:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US