Re: Issues with OUT parameters in stored procedures

From: "Inoue, Hiroshi" <h-inoue(at)dream(dot)email(dot)ne(dot)jp>
To: Thomas Apsel <thomas(dot)apsel(at)opentext(dot)com>
Cc: "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Issues with OUT parameters in stored procedures
Date: 2017-02-21 04:55:39
Message-ID: 2ce51fba-8a5a-1a9a-c2c0-2933c23465c1@dream.email.ne.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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
>
>

Attachment Content-Type Size
convert.diff text/plain 1.5 KB

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Inoue, Hiroshi 2017-02-21 08:29:46 Re: SQLGetTypeInfo tiny column sizes
Previous Message Thomas Apsel 2017-02-20 13:11:58 Issues with OUT parameters in stored procedures