bulk collect

[devmiral]

Hello every one I trying simple bulk collect , it is giving me an error in oracle 9i, i wroe as per book and on the web deatils about bulk collect
declare
type emp_type is table of emp%rowtype;
v_emp_type emp_type;
cursor c is
select empno from emp;
begin
open c;
loop
fetch c bulk collect into v_emp_type;
end loop;
close c;
end;


ERROR at line 9:
ORA-06550: line 9, column 29:
PLS-00597: expression 'V_EMP_TYPE' in the INTO list is of wrong type
ORA-06550: line 9, column 3:
PL/SQL: SQL Statement ignored

[pragatiswain]

Try the following:
declare
type emp_type is table of emp%rowtype;
v_emp_type emp_type;
cursor c is
--select empno from emp;
select * from emp;
begin
open c;
loop
fetch c bulk collect into v_emp_type;
end loop;
close c;
end;

Hope this helps