Stored procedure support for PSQLODBC

Поиск
Список
Период
Сортировка
От Abhishek Kumar
Тема Stored procedure support for PSQLODBC
Дата
Msg-id CAAyULEBOrLq079OLrNjtGMstO8Zszjyygqqtp=b_g1ejshOkmw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Stored procedure support for PSQLODBC
Re: Stored procedure support for PSQLODBC
Список 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

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