Continue on Exception
From: Gnomic <Gnomic_at_swbell.net>
Date: 1997/12/23
Message-ID: <01bd0f61$66f94b20$9914c1cf_at_default>#1/1
end
Date: 1997/12/23
Message-ID: <01bd0f61$66f94b20$9914c1cf_at_default>#1/1
OK, must have missed it. I've RTFM'd on how to continue after an exception and can't find a decent example. I'm trying to do the following:
for i in i_start..i_end loop
insert into tbl (xx,yy) values (aa,bb);
end loop
exception
when others -- like a duplicate record which I don't care about! continue
end
I don't want to read and then write if I can help it since it doubles my I/O. Can anyone point me towards an example? Thanks in advance. Received on Tue Dec 23 1997 - 00:00:00 CET