Oracle 11g stored procedures and Crystal Reports XI

[sqlseer]

Please help. My organization imports reports and expects a Call statement in the Command window of Crystal Reports (instead of a direct link to the database).

We successfully do this with MSSQL, iSeries(AS400), and DB2. We have a new client that uses Oracle 11g.

We also use JDBC connection, so ODBC and OLEDB connections are disabled.

We can get crystal and Oracle to communicate but have to use the JDBC Oracle thin driver (ojdbc6.jar) and connect to the stored procedure by selecting it in the crystal schema tree. Unfortunately, our application does not recieve any data. We've read that Oracle 11g stored procedures do not return result sets and expect this is why the application does not receive data.

Does anyone out there have a similar set up and know how to call a stored procedure from crystal in such a way that a result set is retrieved?

I'm sorry if I'm not being clear, I don't know Oracle all that well in order to refer to the correct technical objects.

 

[Turkbear]

Hi,
The Stored Procedure in Oracle must be coded to return a REFCURSOR ( see example :

http://www.oracle-base.com/articles/misc/UsingRefCursorsToReturnRecordsets.php

)





To Paraphrase:"The Help you get is proportional to the Help you give.."