当前位置: > 数据库 > Oracle >

Oracle存储过程返回结果集

时间:2016-05-08 00:17来源:linux.it.net.cn 作者:IT
create or replace package pa_query as
type p_cursor is ref cursor;
end pa_query;
/
create or replace procedure p_query(v_cursor out pa_query.p_cursor)
is
begin
open v_cursor for select * from hs_school;
end p_query; (责任编辑:IT)
------分隔线----------------------------