declare
user_cur sys_refcursor;
type type_record is record
(
test01 varchar2(32),
test02 varchar2(32),
test03 number
);
rcd type_record;
begin
p_temp_procedure(user_cur);
loop
exit when user_cur%notfound;
fetch user_cur into rcd;
dbms_output.put_line(rcd.test01);
dbms_output.put_line(rcd.test02);
dbms_output.put_line(rcd.test03);
end loop;
end;
用个循环 给你参考。