Re: problem to retrieve stocked procedure with Crystal Report

The Oracle Crystal connection works either way.

But why would you prefer the method that is slowest, least secure, and most prone to errors?

Daniel Morgan

Thomas Goirand wrote:

> Hi,
>
> With Win NT, Crystal Report 8.0.1, Oracle 8.1.7, MDAC 2.7
> i'd like my Crystal Report documents use ODBC instead of the native
> Oracle driver.
> Conversion is working well with my documents which get some tables or
> views, but i've got an error with docs retrieving a cursor from stocked
> procedures:
>
> ODBC error :[Microsoft][ODBC driver for Oracle][Oracle]ORA-06550: line
> 1, column 32:
> PLS-00306: wrong number of argument or types of arguments in call to
> 'STOCKEDPROC'
> ORA-06550: line 1, column 7:
> PL/SQL: Statement ignored
>
> then: cannot open database
> and: file integrity error
>
> also theses documents are working fine with native oracle driver.
>
> is Crystal report able to use ODBC to retrieve oracle stocked-procedures
> whith cursors ?
>
> Thanks for your help
>
> Thomas
Received on Mon Feb 18 2002 - 18:13:46 CST