On Fri, Mar 6, 2009 at 4:29 PM, Asko Oja
<ascoja@gmail.com> wrote:
It was one of my worst Friday's finding out that this brain dead implementation of out parameters had been part of fuck up again.
:)
This time we did notice it two days too late.
I wish for a way to use out parameters in functions only through some predefined prefix like in triggers new and old. Means i would like to limit referencing to out parameters to one prefix only defined in the beginning of declare section of stored procedure.
It really sucks what kind of mistakes you can pass to production unknowingly. I would much prefer a way to prevent such nonsense.
Here was the case where out parameters were with same names with select into field names resulting in null outcome. Just yesterday we had similar case with update statement.
Well, it's a problem with the language not parsing things correctly and doing, in many cases, brain-dead replacements. I don't know of any developer using OUT parameters that doesn't run into this problem at one time or another :(
--
Jonah H. Harris, Senior DBA
myYearbook.com