Re: Procedure Parameter OUT values

WebPat wrote:

I am surprised by the order of the data returned from my stored procedure, and that it appears associated with the incorrect variables. Apparently the data is returned entirely positionally, without consideration for the variable names. So, the names of the OUT parameters in the procedure appear to be invisible outside of the procedure. Although I pass in variables with the same names as the Parameters, they are filled positionally - in the "wrong" variables - because in this case I had two variables reversed positionally. When I retrieve them using fetch_assoc, the wrong data appears in the result.

I'd probably find a more targeted mailing list (a specialized one for your database - whatever it is) and see if they can offer any suggestions. -- Postgresql & php tutorials http://www.designmagick.com/