Skip to Content
Former Member
Mar 24, 2010 at 02:29 AM

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



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.


-Venkat Gopalan