Oracle and cursors

[sablotron]

Whith Crystal Report 8.0.1, Oracle 8.1.7, MDAC 2.7
i'd like to change Crystal Report documents which use native oracle driver to use ODBC.
It's working until i try to change documents which call stocked procedures with cursors.
i've got this error:

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 'MYPROCSTOCK'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

then: cannot open database
and: file integrity error

is Crystal Report working with ODBC and oracle stocked procedures ?

 

[Guest_imported]

For Crystal report to work with stored procedures,
In the stored procedure, the first parameter should be a cursor and followed by any IN parameters.

 

[sablotron]

thanks,
but my stored procedure still doesn't working.
could it be a problem with my stored procedures ?
(they're work'in fine in sqlplus and with ADO)

 

[viji123]

Hi,
I have a similar problem. The stored procedure runs in sql plus , but when I try to use the same stored procedure in CR, it prompts me for the parameter value. When I enter a value, I get the following error : Cannot bind PL/SQL records or cursor references. Hope somebody out there will help....
Viji123

 

[viji123]

Hi Sablotron,
I solved my problem. You might want to check the odbc driver datasource name (DSN) that your CR is using to connect to the stored procedure. If you are using Oracle stored procedure then you can either use Microsoft's native oracle driver or you can configure to use crystal reports oracle driver called Merant. I am using the second one and now I can call my report based on the oracle stored procedure that is on a remote database server.
Hope this helps.
Good Luck....Viji.

 

[deepak1979]

Try using In-Out parameters, it probably doesnt recognize In parameter alone

 

[sablotron]

Arg, it still doesn't work.
What is the right way to call a stored procedure in CR:
When i select location i've got this:
Proc(MY_PACKAGE.MY_STOREDPROC)

is it right ?

I've got Oracle 8i when i try to convert the driver, Crystal Report show:

From: pdsora7.dll (ORACLE 7.x)
To: ...

should it be the problem ?

Thanks