Title: 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



Reply via email to