Philippe,
You could 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" statement in my loop when a request return no data
e.g :
cursor c1 is .....
for c in c1 loop
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 ? */
end loop
TIA
Philippe
Luc Demanche
[EMAIL PROTECTED]
Do You Yahoo!?
Yahoo! Autos - Get free new car price quotes