Oracle Stored Procedure in CR10

[itorient]

Hi, I have been trying to figure this out, nut no success. I have a report created in 8 with an Oracle stored procedure and ran fine with no problem but when ran in 10 it faield with error saying "failed to open rowset". Has anybody experienced this? Any feedback/assistance would be appreciated. Thanks in advance.

 

[pelajhia]

You may need to use a different driver, one that is compatible with Oracle (version ?) and Crystal 10.

 

[Gramm]

Sometimes the failed to open rowset error can be caused by syntax errors. Usually the last phrase of the message gives you a clue as to the acutal problem.

 

[Turkbear]

Hi,
What version of Oracle is the data source and what version of Oracle Client is on the CE server?

What connection type ( ODBC, ADO, Native)?

Does the report run in CR Designer ( from the CE server PC, if possible)?