Oracle Procedure

[dbinfoweb]

Hi, I got an error trying to pull in the procedure I created in Oracle. The error said "Invalid Cursor" Is there any other way to call the procedure in Crystal? Any help will be appreciated.

 

[Mike Lewis]

dbinfoweb,

First thing I would check is to see if the procedure itself runs OK. Can you run the procedure within Oracle or from another client application? If not, you will have to look at the procedure code. If you can run it, how you are trying to access it in CR?

Mike


Mike Lewis
Edinburgh, Scotland

My Visual Foxpro web site:

http://www.ml-consult.demon.co.uk

My Crystal Reports web site:

http://www.ml-crystal.com

 

[synapsevampire]

This is both Crystal and Oracle version dependent.

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

Also make sure that if you're using CR 8.5 and below and you're using ODBC that you check the Procedure Returns Results in the CR ODBC for Oracle driver (don't use the Oracle driver).

-k