Re: Oracle procedures for Crystal Reports

How are you invoking Crystal? Through VB? You can just pass your P1, RC1 to use in the selection criteria or optionally
rewrite your SP to write the 'ref cursor' data to an another table.

HTH,
Tim

"inna" <mednyk_at_hotmail.com> wrote in message news:347a408b.0109211427.450fa00f_at_posting.google.com...
> 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 - 14:46:27 CEST