创建Package:(名称为PackageData)
CREATE OR REPLACE PACKAGE PackageData
IS TYPE DataList IS REF CURSOR;
END;
调用Package:(在存储过程中调用Package以返回游标)游标即数据集合
CREATE OR REPLACE PROCEDURE TEST_PROC
(P_DataSet OUT PackageData.DataList )
AS
BEGIN
OPEN P_DataSet FOR
select * from TestTable;
END;