[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



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