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...
devmiral
Last Activity: Nov 17 '06, 02:25 AM
Joined: Nov 17 '06
Location:
-
bulk collect
hello every one why is this not working, all books say this code but it is not working in oracle 9i1.0
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:...
No activity results to display