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

Home -> Community -> Usenet -> c.d.o.tools -> Re: trigger question

Re: trigger question

From: luio <lctNOlcSPAM_at_hotmail.com.invalid>
Date: 2000/08/01
Message-ID: <042bd014.faae8feb@usw-ex0104-028.remarq.com>#1/1

actual code is like this:
create trigger after delete on table1 for each row begin
--if SQL%rowcount = 0 then return; end if;
delete from table2 where table2.Id = :old.sId; end;

the commented line is trying to check if the row count affected is 0. if 0 return, if not, go on.


Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free!
http://www.keen.com Received on Tue Aug 01 2000 - 00:00:00 CDT

Original text of this message

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