Re: Issues with OUT parameters in stored procedures

Hi,

thank you so much for the quick answer. But we need an official fix in the binary of the psqlodbc driver for our customers. Do you know by when this fix is available in the binary distributions?

I’m not quite familiar with PostGreSQL and I’m only managing this issue for our product. Is there a bugtracker or something like that for PostGreSQL driver and is our bug already added into such a bugtracker (to follow the status)?

Regards,

Thomas

From: Inoue, Hiroshi [mailto:h-inoue(at)dream(dot)email(dot)ne(dot)jp]
Sent: Dienstag, 21. Februar 2017 05:56
To: Thomas Apsel
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: [ODBC] Issues with OUT parameters in stored procedures

Hi Thomas,
On 2017/02/20 22:11, Thomas Apsel wrote:
Hi,

we have here an issue that stored procedures cannot be found. This issue comes up with the newest psqlodbc version. The following information is from my colleague (he is currently not in the office) and I hope that this information is enough to verify the issue.

Thanks for the info.
I can verify the issue.

Would be fine if you can us a hint how to adjust the attached sample “params-out-test.c” or better you can fix the bug in the psqlodbc driver.

A workaround is to call SQLPrepare() and SQLExecute() instead of calling SQLExecDirect().
Attached is a patch to fix this issue.

regards,
Hiroshi Inoue

Thank you for your help.

Regards,

Thomas Apsel