如果要在其他地方要调用这个存储过程(pkg_resultset.proc_resultset)并遍历结果集(p_page), 你可以用类似于如下的方法即可!
declare
cur pkg_resultset.each_page;
arr dept%rowtype;
begin
pkg_resultset.proc_resultset(cur);
loop
fetch cur into arr;
exit when cur%notfound;
/*write to codes to process datas*/
end loop;
close cur;
end;
declare
cur pkg_resultset.each_page;
arr dept%rowtype;
begin
pkg_resultset.proc_resultset(cur);
loop
fetch cur into arr;
exit when cur%notfound;
/*write to codes to process datas*/
end loop;
close cur;
end;