Postgres Pro
Downloads
Home   >   mailing lists

Thread: Stored procedure support for PSQLODBC

Stored procedure support for PSQLODBC

From
Abhishek Kumar
Date:
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

Re: Stored procedure support for PSQLODBC

From
Adrian Grucza
Date:
Yes, you need to omit the curly braces.

Curly braces is ODBC syntax, and because PostgreSQL used to only have functions and not procedures, the driver maps this syntax to functions. By omitting the curly braces you are using the native PostgreSQL CALL syntax which executes a procedure.


iress.com
Adrian Grucza​​​​  
Technical Lead
Office: +61390185800
adrian.grucza@iress.com
www.iress.com
Level 16 385 Bourke St
 Melbourne, Victoria, 3000
The contents of this email originated from Iress. For this purpose Iress includes Iress Limited and/or any of its subsidiaries, holding companies and trading entities. ​If you have received this email in error please notify the sender immediately and delete this email. 
nosig
On Wed, 25 Sept 2024 at 16:22, Abhishek Kumar <abhishek.aak0@gmail.com> wrote:


CAUTION: This Email is from an EXTERNAL source. Ensure you trust this sender before clicking on any links or attachments.


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

Re: Stored procedure support for PSQLODBC

From
Dave Cramer
Date:
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