declare
...
type t_ref is ref cursor;
c_ref t_ref;
begin
...
open c_ref for 'select * from ....';
loop
fetch c_ref into c_ref;
exit when c_ref%notfound;
end loop;
close c_ref;
...
end;
...
type t_ref is ref cursor;
c_ref t_ref;
begin
...
open c_ref for 'select * from ....';
loop
fetch c_ref into c_ref;
exit when c_ref%notfound;
end loop;
close c_ref;
...
end;