Stored Procedure error "Invalid Cursor"

[prox]

Hello,
I have a problem when I try to use an ORACLE Stored Procedure as DataSource for a report.
I'm already using a Stored Procedure for another report and it works.
But, dfor this particular report, I followed the Crystal Instruction and it dosn't work.
The error is :
"ORA-00000 Normal, succesful completion"
or "Invalid Cursor".
Where's the problem?
Thanks in advance.

Prox

 

[synapsevampire]

I'd guess that it's the way that your SP is designed, CR is very particular about how SP's are constructed.

Without seeing the SP it's hard to tell, but since you have one that works, the logical assumption is that the SP is invalid for CR.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com