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;
end loop
"NGUYEN Philippe (Cetelem)" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED] 07/15/02 03:38 PM
|
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: cursor and no data found |
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