有点晕 下面的代码为啥有错?
-- Created on 2011/4/6 by HOHO_LIU
declare
-- Local variables here
result1 sys_refcursor;
str varchar2(100);
begin
-- Test statements here
open result1 for
select 'abc' from dual;
--test1
/* loop
fetch result1 into str;
dbms_output.put_line(str);
exit when result1%notfound;
end loop; */
--test2
for rec in result1
loop
null;
end loop;
end;
-- Created on 2011/4/6 by HOHO_LIU
declare
-- Local variables here
result1 sys_refcursor;
str varchar2(100);
begin
-- Test statements here
open result1 for
select 'abc' from dual;
--test1
/* loop
fetch result1 into str;
dbms_output.put_line(str);
exit when result1%notfound;
end loop; */
--test2
for rec in result1
loop
null;
end loop;
end;
http://z-jianwen.iteye.com/blog/798964
只能使用
loop
fetch into
exit when cursorname%notfound
end loop