BDY.RTF
Description: RTF file
cursor c1 is .
for c in c1 loop
begin
select a into v1
from table1
where a 1 and b 2 and ...
/* if my select into return no data ?
how can I tell him to goes on into the loop ? */
Exception
when no data found
then
null;
end;
Hi Philippe
You can write the following after the select statement:
exception
when no_data_found then null;
regards,
Ams.
www.medicomsoft.com
Hi List !
how can I can make a continue statement in my loop when a request return
no data
e.g :
cursor c1 is .
for c in c1 loop
select
Philippe,
Youcould use PL/SQL exceptions.
Example :
for c in c1 loop
begin
select a into v1 from table1 where a 1 and b 2 and ...
exception
when no_data_found then
null;
end;
end loop;
Luc
"NGUYEN Philippe (Cetelem)" <[EMAIL PROTECTED]>wrote:
Hi List ! how can I can make a "continue"