On Fri, Mar 6, 2009 at 4:29 PM, Asko Oja <asc...@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