在oracle存储过程中返回数据集

CREATE OR REPLACE PACKAGE pkg_test
AS
    TYPE myrctype IS REF CURSOR;
    PROCEDURE liu_test(startCode varchar2,endCode varchar2,pname varchar2,p_rc OUT myrctype);
END pkg_test;

CREATE OR REPLACE PACKAGE BODY pkg_test
AS
procedure liu_test (startCode varchar2,endCode varchar2,pname varchar2,p_rc OUT myrctype)
is
begin
OPEN p_rc FOR
select * from ibusiness_100w where id in (select min(id) from ibusiness_100w  WHERE AreaID BETWEEN startCode AND endCode AND contains(keyword,pname)>0 group by TradeID );
end liu_test;
END pkg_test;