如何在oracle中接收游标变量并得到值
程序员文章站
2022-03-28 23:22:15
...
declare
v_result number;
type v_cursor is ref cursor;
v_cur v_cursor;
v_row nanProductInfo%rowtype;
begin
OperaToNanInfo.DORESEARCH(v_result,v_cur);
dbms_output.PUT_LINE(v_result);
fetch v_cur into v_row;
while v_cur%found
loop
dbms_output.PUT_LINE(v_row.name);
fetch v_cur into v_row;
end loop;
end;
v_result number;
type v_cursor is ref cursor;
v_cur v_cursor;
v_row nanProductInfo%rowtype;
begin
OperaToNanInfo.DORESEARCH(v_result,v_cur);
dbms_output.PUT_LINE(v_result);
fetch v_cur into v_row;
while v_cur%found
loop
dbms_output.PUT_LINE(v_row.name);
fetch v_cur into v_row;
end loop;
end;