I am working on updating a reporting system that uses Crystal Reports. All of the 250+ reports were created in CR 8 and I have been opening up the old files in Visual Studio 2005 and updating the database location. All I have had to do with all connections to views and even a couple of stored procedures is create a new connection to the database and then update the old report's datasource location. The reason I need to update the location is so that the .NET application will use the correct driver. Everything has worked fine up until I got to one stored procedure. The old version of the report works perfectly with the stored procedure, but when I try to run the report using VS 2005 I keep getting errors.
First I connected to the database using the Oracle OLE DB provider, then updated the location of the stored procedure in the report. It then prompts me for the two parameter values for the stored procedure, both of which I keep as NULL so that the report parameters will be passed to the procedure. Then I get the following error:
Query Engine Error: 'ADO Error Code: 0x
Description: ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'STORED_PROCEDURE'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored'
View Complete Post