Output parameters - Mailing list pgsql-odbc

From Bart Samwel
Subject Output parameters
Date
Msg-id 446AE2CF.5070607@samwel.tk
Whole thread Raw
Responses Re: Output parameters  (Hiroshi Inoue <inoue@tpf.co.jp>)
List pgsql-odbc
Hi there,

I've got a situation with the experimental enhanced branch driver
(version 7.03.02.66), PostgreSQL 8.1 backend. I'm executing a query such as:

SELECT myproc(?,?,?,?,?,?,?)

where a number of the parameters are output parameters. I've bound
buffers to the output parameters, but when I read the values, they
contain garbage (uninitialized data, to be precise -- 0xcdcdcdcd). The
first result row then contains the output parameter values. I'd expect
the result row, as this is how PostgreSQL implements output parameters,
but does anybody have any clue why the bound buffers for the output
parameters aren't filled?

Thanks in advance for your help!

Cheers,
Bart


pgsql-odbc by date:

Previous
From: "Jonathan Blitz"
Date:
Subject: SQLCODE when using psqlODBC with libODBC++
Next
From: Hiroshi Inoue
Date:
Subject: Re: Output parameters