Re: Oracle procedures for Crystal Reports

mednyk_at_hotmail.com (inna) 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.

The thing is, that we can't use tables because we have same procedures for SQLServer for same reports. And it suppose to work with Oracle procedures as well. So Is there another solution? Received on Mon Sep 24 2001 - 15:25:22 CEST