存储过程:
Package Head:
CREATE OR REPLACE PACKAGE TEST IS
--返回cursor
TYPE CURSOR_RESULT IS REF CURSOR;
PROCEDURE GET_CURSOR_RESULT(P_STARTINDEX IN INT,
P_LIMIT IN INT,
P_DEAL_TYPE IN VARCHAR2,
CR OUT CURSOR_RESULT);
END TEST;
Package Body:
CREATE OR REPLACE PACKAGE BODY TEST IS
PROCEDURE GET_CURSOR_RESULT(P_STARTINDEX IN INT,
P_LIMIT IN INT,
P_DEAL_TYPE IN VARCHAR2,
CR OUT CURSOR_RESULT) IS
BEGIN
OPEN CR FOR
SELECT T.*
FROM (SELECT SDD.ID, SDD.FCU, SDD.FCD, ROWNUM RN
FROM SDDTEST SDD
WHERE DEAL_TYPE = P_DEAL_TYPE) T
WHERE T.RN >= P_STARTINDEX
AND T.RN < P_STARTINDEX + P_LIMIT;
END GET_CURSOR_RESULT;
END TEST;
存储过程:Package Head:CREATE OR REPLACE PACKAGE TEST IS --返回cursor TYPE CURSOR_RESULT IS REF CURSOR; PROCEDURE GET_CURSOR_RESULT(P_STARTINDEX IN INT, P_LIMIT IN