Crystal REport sbased on Oracle Stored procedure (returnin gmultiple r

[regisacc]

Did any body create a crystal report using an oracle stored procedure returning multiple rows. Please give me any ideas of how to do this. I have created a stored procedure in oracle returning multiple records into a ref cursor.Now my problem is to buld a report based on this out put.
Thank You.

 

[synapsevampire]

There's a FAQ on the Seagate site:

http://support.crystaldecisions.com/communityCS/TechnicalPapers/scr_oracle_stored_procedures.pdf.asp

Here's an overview:

Create a SP using a ref cursor as described in the FAQ

Create an Oracle ODBC connection using the CR Oracle ODBC driver, be sure to select Procedure Returns Results in the Advanced tab.

Create a report based on this ODBC connection, and the parameter will automatically appear in your report.

There are lots of headaches when using an SP in Oracle, but it does work.

-k

 

[regisacc]

It worked . Problem was with Drivers. I used CR Oracle v3.6 driver it worked!!
Thank You very much