Postgres Pro
Downloads
Home   >   mailing lists

Stored procedure support for PSQLODBC - Mailing list pgsql-odbc

From Abhishek Kumar
Subject Stored procedure support for PSQLODBC
Date
Msg-id CAAyULEBOrLq079OLrNjtGMstO8Zszjyygqqtp=b_g1ejshOkmw@mail.gmail.com
Whole thread Raw
Responses Re: Stored procedure support for PSQLODBC
Re: Stored procedure support for PSQLODBC
List pgsql-odbc
Tree view
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: Dave Cramer
Date:
Subject: Re: syntax error at or near "ROWS"
Next
From: Adrian Grucza
Date:
Subject: Re: Stored procedure support for PSQLODBC