Crystal Reports Set Datasource Location Error

Message

   Hi All,

Crystal Reports 11

Oracle 10g

I am trying to change the data source.

Need to change the current data source from CMMBSSUM (having 4 
parameters) to CMMBSSUM_ST (having 5 parameters). Both these stored 
procedures are in CCBUAT environment.

I have a report HSTD.rpt using stored procedure CMMBSSUM as datasource

This stored Procedure has 4 parameters

   1. User id

   2. From date

   3. To date

   4. 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

   1. User id

   2. From date

   3. To date

   4. Service Type

   5. 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

   1. User id

   2. From date

   3. To date

   4. 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/">