Stored procedure support for PSQLODBC

From: Abhishek Kumar <abhishek(dot)aak0(at)gmail(dot)com>
To: pgsql-odbc(at)lists(dot)postgresql(dot)org
Subject: Stored procedure support for PSQLODBC
Date: 2024-09-25 06:21:57
Message-ID: CAAyULEBOrLq079OLrNjtGMstO8Zszjyygqqtp=b_g1ejshOkmw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Adrian Grucza 2024-09-25 06:42:40 Re: Stored procedure support for PSQLODBC
Previous Message Dave Cramer 2024-09-19 13:31:46 Re: syntax error at or near "ROWS"