DB Read SQL error when using stored procedures

Unanswered Question
Aug 31st, 2007
User Badges:

I have a couple scripts that I've been using stored procedures in and working fine. I have a few new stored procedures that I'm having trouble with now. These SPs are to enter data into the DB. I still use the DB Read bean since the DB Write will not work with stored procedures.


If I run them with information populated they run just fine and I get my resulting integer to let me know whether or not the SQL server accepted the data. When I try to use CRS variables the CRS Editor balks with the attached error.


Here is an example of something that works:


DECLARE @return_status int

EXEC @return_status = uspIVRSetCreditCardExpira @Account_Number = 254545,

@Expire_Date = '8/31/2010'

SELECT 'Return_Status' = @return_status



And the same thing with just an added string variable ($CreditCardExpInsert):


DECLARE @return_status int

EXEC @return_status = uspIVRSetCreditCardExpira @Account_Number = 254545,

@Expire_Date = $CreditCardExpInsert

SELECT 'Return_Status' = @return_status



I don't know a lot about SQL so I'm not really sure what I'm missing here. Any thought on why I get this error?

Thanks,


Mike



  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (1 ratings)
Loading.
bilalghayad Mon, 03/10/2008 - 02:02
User Badges:

Hi;


The above written scripts to be done in the CRS? Where exactly? Using which node?


When to use ODBC and when to call the stored procedure directly without the ODBC? Any advise?


Regards

Bilal

bilalghayad Mon, 03/10/2008 - 02:04
User Badges:

Hi;


The above written scripts to be done in the CRS? Where exactly? Using which node?


When to use ODBC and when to call the stored procedure directly without the ODBC? Any advise?


Regards

Bilal

Actions

This Discussion