大家好,今天练习写了下面的游标,但是编译的时候报错了,麻烦给指点下,谢谢
create or replace procedure cursortest1
is
idnamevarchar2(14);
ilocvarchar2(13);
cursor cselectdept
is
select dname,loc
from scott.dept;
begin
open cselectdept;
loop
fetch cselectdept
into idname,iloc;
exit when cursortest1%notfound;
dbms_output.put_line(idname||iloc);
end loop;
close cselectdept;
end;
/