Data Connectivity
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Data Connectivity
Message Icon Topic: Set Datasource Location Error Post Reply Post New Topic
Author Message
gnk_bo
Newbie
Newbie


Joined: 04 Aug 2010
Location: United States
Online Status: Offline
Posts: 2
Quote gnk_bo Replybullet Topic: Set Datasource Location Error
    Posted: 04 Aug 2010 at 11:12am
Hi All,
Crystal Reports 11
Oracle 10g

I have a report HSTD.rpt having stored procedure CMMBSSUM
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/">
Thanks,
GNK_BO
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.