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)
| 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) |