We currently run Crystal Reports v10 with ODBC (CR Oracle ODBC Driver 4.20) to Oracle 9i database (on solaris) and have some reports which gets data (ref cursors) from stored procedures. So far so good and now we are upgrading our oracle database to 10g on Linux server and during my testing these reports give the following error.
Failed to open rowset
Query Engine Error: HY000:[DataDirect][ODBC Oracle driver]ORA-06550:line 1, column 8:
PLS-00306: wrong number or types of arguments in call to 'MY_STORED_PROCEDURE'
ORA-06550: line1, column 35:
PLS-00363: expression 'MY_PARAM_VALUE' cannot be used as an assignment target
ORA-6550: lin1, column8:
Any help would be greatly appreciated.