Crystal Reports Set Datasource Location Error

Message

   Hi All,

Crystal Reports 11 

Oracle 10g

I have a report HSTD.rpt having stored procedure CMMBSSUM

This stored Procedure has 4 parameters 

	User id

	From date

	To date
Service type

Now user wants to add Service Agreement Type also as a parameter and for that I have created another stored procedure CMMBSSUM_ST. We did not wanted to update the existing stored procedure, because it may impact other reports.

So now CMMBSSUM_ST stored Procedure has 5 parameters 

	User id
From date

	To date

	Service Type
Service Agreement Type

Both the stored procedures are in same database.

When I tried to change the data source “Set Datasource Location” 
change the stored procedure and hit update.
I got the pop up window for Prompts and this is of CMMBSSUM
with following parameters
User id

	From date

	To date

Service type

After I entered all the values and hit ok button.

I get the error.  

Database Connector Error:'HY000:[Oracle][ODBC][Ora]ORA-06550:line 1, column 7:
PLS-00306:wrong number or types of arguments in call to 'CMMBSSUM_ST'
ORA-06550: line 1, column 7:
PL/SQL: Stament ignored
[Database vendor code:6550]

Please help me resolve this error.

Your help is highly appreciated
< ="text/">