[CR #280073] On all systems, using an extended stored procedure (ESP) with parameters may result in wrong data being send to XP Server. Because of this, XP Server may return incorrect results.
This happens when there is no parameter declaration list in the ESP, but one or more parameters are supplied at execution time. Before CR #280073, all parameters supplied at execution time were sent to the XP Server, causing incorrect results. CR #280073 fixes this problem by silently ignoring all parameters supplied at execution time when the parameter declaration list is empty.
This fix does not cause any behavior change when the parameter declaration list in the ESP matches the parameters supplied at execution time.
If you are using ESPs without a parameter declaration list, and you supply parameters at execution time, drop and re-create the ESP in Adaptive Server. Make sure the parameter declaration list in the ESP matches the parameter list supplied at execution time
You can use trace flag 523 to revert to pre-CR280073 behavior. This is a server-wide trace flag to be set when you restart Adaptive Server.
| Copyright © 2006. Sybase Inc. All rights reserved. |
|
|
