Oracle:存储过程返回结果集

create or replace procedure p_test(p_cur out sys_refcursor)
as
begin
     open p_cur for select * from F_RELATION;
end p_test;


DECLARE
test_cur sys_refcursor  ;
begin
p_test(test_cur);
end;


posted @ 2017-05-16 15:37  甜菜波波  阅读(781)  评论(0编辑  收藏  举报