Re: Stored procedure support for PSQLODBC

Поиск
Список
Период
Сортировка
От Dave Cramer
Тема Re: Stored procedure support for PSQLODBC
Дата
Msg-id CADK3HHJ7_6uSmYhs=5BTyinBRt424xyg-M+w-yBZhDwChPhqrQ@mail.gmail.com
обсуждение исходный текст
Ответ на Stored procedure support for PSQLODBC  (Abhishek Kumar <abhishek.aak0@gmail.com>)
Список pgsql-odbc
Дерево обсуждения
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

В списке pgsql-odbc по дате отправления: