Failed to open rowset, PLS-00306 Wrong Number of arguments in call to....

[Former Member]

Hi,

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.

Error Description:

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:

PL/SQL: Stateme'

Any help would be greatly appreciated.

Thanks,

-Venkat Gopalan

[former_member11696 · Accepted solution]

Discovered on another post that 4.2 is too old. You need to upgrade to a more current ODBC driver that runs on Solaris.

We have a newer one version 5.3 but it's only for windows. Go to Datadirect.com and see if they have one for that OS.

Otherwise you'll have to configure your reports to use the native Oracle driver.

Thank you

Don