From: | Dave Cramer <davecramer(at)postgres(dot)rocks> |
---|---|
To: | Abhishek Kumar <abhishek(dot)aak0(at)gmail(dot)com> |
Cc: | pgsql-odbc(at)lists(dot)postgresql(dot)org |
Subject: | Re: Stored procedure support for PSQLODBC |
Date: | 2024-09-26 11:13:18 |
Message-ID: | CADK3HHJ7_6uSmYhs=5BTyinBRt424xyg-M+w-yBZhDwChPhqrQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Abhishek Kumar | 2024-09-26 18:24:33 | Error codes returned by SQLGetDiagRec |
Previous Message | Adrian Grucza | 2024-09-25 06:42:40 | Re: Stored procedure support for PSQLODBC |