Re: Stored procedure support for PSQLODBC

Good Morning Abhishek,

Can you file an issue on github Issues · postgresql-interfaces/psqlodbc
(github.com) <https://github.com/postgresql-interfaces/psqlodbc/issues>
<https://github.com/postgresql-interfaces/psqlodbc/issues>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(dot)aak0(at)gmail(dot)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
>
>