Re: Output parameter when calling Sybase Stored procedure

[Ryszard Jedrychowski <Ryszard_Jedrychowski@CARDLINK.CO.NZ>]

I often call stored procedure from SQR. I usually use the following syntax:

execute do=print_details stored_procedure_name $string_param #int_param
into      &output_parameter1    char(40),
     &output_parameter1 int,
     &output_parameter1 datetime,
     etc

begin-procedure print_details
    do whatever you like with output parameters
end-procedure

Ryszard





lkarimundackal@JHANCOCK.COM on 18/08/99 06:22:49 AM

Please respond to SQR-USERS@list.iex.net

To:   SQR-USERS@list.iex.net
cc:    (bcc: Ryszard Jedrychowski/Cardlink/NZ)
Subject:  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