3,491
社区成员
发帖
与我相关
我的任务
分享
[SYS@myoracle] SQL>var myrefcursor refcursor
declare
v_a table1.a%type;
v_b table1.b%type;
v_c table1.c%type;
begin
select a,b,c
into v_a,v_b,v_c
from table1
where rownum = 1;
:myrefcursor := package.function(v_a,v_b,v_c);
end;
print myrefcursor;