Re: trigger question

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