PROCEDURE sms_test is scr_sms sys_refcursor v_sms_rec recsms_receive%rowtype; begin sms_recv_carry(scr_sms); loop fetch scr_rec into v_sms_rec; exit when csr_sms_rec%notfound; dbms_output.put_line(v_sms_rec.RSMS_NUMBER); end loop; end sms_test / 没有在机器上运行,仅供参考,呵呵
is
scr_sms sys_refcursor
v_sms_rec recsms_receive%rowtype;
begin
sms_recv_carry(scr_sms);
loop
fetch scr_rec into v_sms_rec;
exit when csr_sms_rec%notfound;
dbms_output.put_line(v_sms_rec.RSMS_NUMBER);
end loop;
end sms_test
/
没有在机器上运行,仅供参考,呵呵