17,377
社区成员
发帖
与我相关
我的任务
分享
create or replace procedure test
IS
Type MyRefCur IS Ref Cursor;
vRefCur MyRefCur;
type type_refcursor is table of cmcs_res_bts_area%rowtype;
v_refcursor type_refcursor;
Begin
OPEN vRefCur FOR Select * from cmcs_res_bts_area;
fetch vRefCur bulk collect into v_refcursor;
Close vRefCur;
for i in 1..v_refcursor.count loop
DBMS_OUTPUT.put_line(v_refcursor(i).area_id);
end loop;
end test;