procedure返回结果集用的是out参数呀,只要你的procedure返回的out参数是sys_refcursor就可以了比如:create or replace package prac is procedure pro1(v1 in number, v2 out sys_refcursor); procedure pro2(v1 in number, v2 out sys_refcursor);
和我看的资料不一样喔,我看的资料是这样写的: create or replace package pp as type mycursor is ref cursor; procedure subselect(aa in number,bb out mycursor); end; create or replace package body pp as procedure subselect(aa in number,bb out mycursor) is begin open bb for select ss.id,ss.name from ss where ss.id=aa; end; end;不知用你的方法该怎么写?本人初学者。
is
procedure pro1(v1 in number, v2 out sys_refcursor);
procedure pro2(v1 in number, v2 out sys_refcursor);
create or replace package pp as
type mycursor is ref cursor;
procedure subselect(aa in number,bb out mycursor);
end; create or replace package body pp as
procedure subselect(aa in number,bb out mycursor) is
begin
open bb for
select ss.id,ss.name
from ss
where ss.id=aa;
end;
end;不知用你的方法该怎么写?本人初学者。