you can need also a bulk collect

hier an example:
declare
nr_var_tab nr_tab NUMBER := nr_tab();
text_var_tab text_tab VARCHAR2(50);

begin

open c1;
loop
fetch c1 bulk collect into
nr_var_tab, text_var_tab LIMIT 10;
exit when c1%notfound;
end loop;
end;
/

I hope you understand me because my English is bad, but i waant to learn it