From: | "Inoue, Hiroshi" <h-inoue(at)dream(dot)email(dot)ne(dot)jp> |
---|---|
To: | "J(dot)Bartkowiak (Inetia)" <jaroslaw(dot)bartkowiak(at)inetia(dot)pl> |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: psqlODBC driver does not support escape sequence for calling SQL procedures '{call procedure-name[([parameter][,[parameter]]...)]}' |
Date: | 2019-10-15 11:40:27 |
Message-ID: | 6f7742c4-b3ac-3b9d-b1bb-c55d3e743226@dream.email.ne.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hi Jarek,
There was a discussion of the CALL behavior:
https://www.postgresql.org/message-id/4285.1537201440%40sss.pgh.pa.us .
regards,
Hiroshi Inoue
<https://www.postgresql.org/message-id/4285.1537201440%40sss.pgh.pa.us>
On 2019/10/14 22:16, J.Bartkowiak (Inetia) wrote:
> ODBC Driver version: 12.00
> PostgreSQLdatabase version: PostgreSQL 12.0
> Operating system: Windows 10 Pro
>
> SQL-level procedures (new in PostgreSQL 11) are not supported by ODBC
> call sequence '{call procedure-name[([parameter][,[parameter]]...)]}'.
>
> Example:
>
> Definition of SQL my_proc() procedure:
>
> CREATE OR REPLACE PROCEDURE my_proc()
> AS $$
> BEGIN
> raise notice 'Hello from my_proc() procedure.';
> END;
> $$ LANGUAGE plpgsql;
>
> Call to procedure my_test():
>
> SQLExecDirect(hstmt, "{call my_test()}", SQL_NTS);
>
> returns error 'my_test() is a procedure;'.
>
> The problem is that psqlODBC driver is treating procedures like
> functions and translates '{call ...}' to 'SELECT * FROM ...', which is
> wrong for procedures. They must be executed using 'CALL' keyword.
>
>
> Regards,
> Jarek Bartkowiak
--
このメールは、AVG によってウイルス チェックされています。
http://www.avg.com
From | Date | Subject | |
---|---|---|---|
Next Message | Christoph Gößmann | 2019-10-15 17:43:48 | Compile Errors on Mac OS X 10.14.6 (fatal error: 'iODBC/sqltypes.h' file not found) |
Previous Message | Inoue, Hiroshi | 2019-10-15 10:50:33 | Re: pgsql 12.0 |