To pass values in the parameters, use this format:
@parameter = @variable
You cannot pass constants; there must be a variable name to “receive” the return value. The parameters can be of any Adaptive Server datatype except text, unitext, or image.
If the stored procedure requires several parameters, either pass the return value parameter last in the execute statement or pass all subsequent parameters in the form @parameter = value.
Copyright © 2005. Sybase Inc. All rights reserved. |