sys_refcursor简单实例

procedure 存储过程名称(参数1 varchar2,参数2 number,返回参数1 out number,返回参数2 out varchar2)
is
v_cursub sys_refcursor;
v_cnt pls_integer;
v_id number;
begin
                  
  open v_cursub for 'select a.id from stp'||user||' a
                        where b.cloid is null';
  
  loop
    fetch v_cursub into v_id;
    exit when v_cursub%notfound;
        --操作内容
  end loop;
exception when others then
  rollback;
  v_res_code:=0;
  v_res_msg:=sqlerrm;
end 存储过程名称;