rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 12th, 2006

 

No you can not store the cursor variable into pl/sql table

but yes the out put or cursor variable can be stored how:

set serveroutput on

declare
type v_table is table of emp%rowtype index by binary_integer;
my_table v_table;
i number;
cursor c1 is select * from emp;
begin
i := 1;
open c1;
loop
fetch c1 into my_table(i);
exit when c1%notfound;
i := i + 1;
end loop;
for r in 1.. my_table.count
loop
dbms_output.put_line(my_table(r).empno);
end loop;
end;