oracle 9i 以上版本直接使用sys_refcursor就可以了 create or replace procedure getResultData(rst out sys_refcursor) is begin open rst for select * from t; end getResultData;
oracle 8i需要自定义游标create or replace package pkg_getResultData is type ResultData is ref cursor; procedure getResultData(rst out ResultData); end pkg_getResultData; / create or replace package body pkg_getResultData is procedure getResultData(rst out ResultData) is begin open rst for select * from t; end; end pkg_getResultData;
oracle 9i 以上版本直接使用sys_refcursor就可以了
create or replace procedure getResultData(rst out sys_refcursor) is
begin
open rst for select * from t;
end getResultData;
oracle 8i需要自定义游标create or replace package pkg_getResultData is
type ResultData is ref cursor;
procedure getResultData(rst out ResultData);
end pkg_getResultData;
/
create or replace package body pkg_getResultData is
procedure getResultData(rst out ResultData) is
begin
open rst for select * from t;
end;
end pkg_getResultData;