oracle调用返回游标的存储过程
In SQL Developer
SET SERVEROUTPUT ON
declare cur_out_arg CURSORTYPE; idvalue number; begin dbms_output.put_line('------------------------'); SPNAME(cur_out_arg, arg1, arg2); loop fetch cur_out_arg into idvalue; exit when cur_out_arg%notfound; dbms_output.put_line(idvalue); end loop; end; /