Postgres Pro
Downloads
Home   >   mailing lists

Re: Stored procedure support for PSQLODBC - Mailing list pgsql-odbc

From Dave Cramer
Subject Re: Stored procedure support for PSQLODBC
Date
Msg-id CADK3HHJ7_6uSmYhs=5BTyinBRt424xyg-M+w-yBZhDwChPhqrQ@mail.gmail.com
Whole thread Raw
In response to Stored procedure support for PSQLODBC  (Abhishek Kumar <abhishek.aak0@gmail.com>)
List pgsql-odbc
Tree view
Good Morning Abhishek,

It would be very useful if you could provide a small program to replicate the issue.

Dave Cramer
www.postgres.rocks


On Wed, 25 Sept 2024 at 02:32, Abhishek Kumar <abhishek.aak0@gmail.com> wrote:
Hi,

I am trying to execute a stored procedure query using SQLExecDirect of psqlodbc driver.

The sample statement is below
{call public.SXRCXT18_GETDESC1( ?, ? )}

I am getting an error - 
ERROR: public.sxrcxt18_getdesc1(unknown, unknown) is a procedure;
Error while executing the query SQLNativeErr = {3} SQLErrorText = {4}.
SQLEXEC Id1 error (SQLState = ERROR: public.sxrcxt18_getdesc1(unknown, unknown) is a procedure;
Error while executing the query SQLNativeErr = {3} SQLErrorText = {4}

Can you please tell me the reason for this? Is there a different way to call stored procedure ?

Regards,
Abhishek Kumar

pgsql-odbc by date:

Previous
From: Adrian Grucza
Date:
Subject: Re: Stored procedure support for PSQLODBC
Next
From: Abhishek Kumar
Date:
Subject: Error codes returned by SQLGetDiagRec