| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Prajakta Chinchole <prajakta(dot)chinchole(at)hcl(dot)com> |
| Cc: | "pgsql-sql(at)lists(dot)postgresql(dot)org" <pgsql-sql(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Support for PostgreSQL stored procedure through ITX. |
| Date: | 2021-07-09 13:42:45 |
| Message-ID: | 2091963.1625838165@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Prajakta Chinchole <prajakta(dot)chinchole(at)hcl(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rob Sargent | 2021-07-09 16:32:21 | Re: Sort a table by a column value that is a column name? |
| Previous Message | Prajakta Chinchole | 2021-07-09 05:53:46 | Support for PostgreSQL stored procedure through ITX. |