[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Output parameter when calling Sybase Stored procedure
- Subject: Output parameter when calling Sybase Stored procedure
- From: "Karimundackal, Liz J." <lkarimundackal@JHANCOCK.COM>
- Date: Tue, 17 Aug 1999 13:22:49 -0400
Hi SQR gurus,
I hope some one can help me with this.
There is a sybase stored procedure which updates a field in the
database and
has two parameters one of which is an OUTPUT parameter which will
contain any
error code.
I call this Stored Proc using the Execute command as follows:
Execute @#return_status = usp_update $Input_Var #Output_Var OUTPUT
I get the correct return value, but nothing gets populated in the
#Output_var even
though an error has occured and the Store Proc is populating its
Output variable.
I am at my wits end with this. I hope somebody who has done
something similar
will help me!!!
Thank you for your patience.
Liz