agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: Tom Lane <tgl@sss.pgh.pa.us>
To: Prajakta Chinchole <prajakta.chinchole@hcl.com>
Cc: pgsql-sql@lists.postgresql.org <pgsql-sql@lists.postgresql.org>
Subject: Re: Support for PostgreSQL stored procedure through ITX.
Date: Fri, 09 Jul 2021 09:42:45 -0400
Message-ID: <2091963.1625838165@sss.pgh.pa.us> (raw)
In-Reply-To: <PS1PR04MB27587E6655BA9B07187C134D8B189@PS1PR04MB2758.apcprd04.prod.outlook.com>
References: <PS1PR04MB27587E6655BA9B07187C134D8B189@PS1PR04MB2758.apcprd04.prod.outlook.com>
Prajakta Chinchole <prajakta.chinchole@hcl.com> writes:
> We are trying to execute a PostgreSQL stored procedure through ITX. We are using ODBC driver that was provided with PostgreSQL. We observed that sqlExecDirect() failed for stored procedure with below error :
> DIAG [42809] ERROR: public.transfer(integer, integer) is a procedure;
> Error while executing the query (1)
You might have more luck asking about this on the pgsql-odbc mailing list.
Also, make sure you're using an up-to-date release of the ODBC driver.
regards, tom lane
view thread (2+ messages)
Message-ID: <2091963.1625838165@sss.pgh.pa.us>
Permalink: ../2091963.1625838165@sss.pgh.pa.us/
Also on: postgresql.org/message-id/2091963.1625838165@sss.pgh.pa.us
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, prajakta.chinchole@hcl.com, pgsql-sql@lists.postgresql.org
Subject: Re: Support for PostgreSQL stored procedure through ITX.
In-Reply-To: <2091963.1625838165@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox