Oracle procedures for Crystal Reports

How to create Oracle procedure for Crystal Report? Usually I am using Package and Package body And Ref cursor. Now as I understood that I can't use them anymore, so what should I do? there is ex. of what we are using:

CREATE OR REPLACE PACKAGE PUSER.CURRQCURRHIST AS
TYPE RCT1 IS REF CURSOR;
PROCEDURE CURRQCURRHIST
(P1 INTEGER,

RC1 IN OUT RCT1);
END;
/

CREATE OR REPLACE PACKAGE BODY PUSER.CURRQCURRHIST AS
PROCEDURE CURRQCURRHIST
(P1 INTEGER,

RC1 IN OUT RCT1)
AS
BEGIN
OPEN RC1 FOR
SELECT TCurrRate.UNIQUEID, TCurrRate.RATE, TCurrRate.STARTDATE, TCurrRate.ENDDATE FROM TCurrRate
WHERE (((TCurrRate.CurAssocid)=P1))
ORDER BY TCurrRate.STARTDATE DESC, TCurrRate.ENDDATE DESC; END;
END;
/
What is the solution for crystal reports for same procedure Thank you. Received on Sat Sep 22 2001 - 00:27:26 CEST