Support for CALL statement in ecpg

Поиск
Список
Период
Сортировка
От Ashutosh Sharma
Тема Support for CALL statement in ecpg
Дата
Msg-id CAE9k0Pn3s_YcOJpDMhZwaSaQ2YbKS-2hNCCVG=+WF85-R-20gQ@mail.gmail.com
обсуждение исходный текст
Список pgsql-interfaces
Hi All,

In the current code for ecpg, we can't use CALL statement to call
stored procedures. The attached patch adds the support for it.

With the attached patch, we can now have the following SQL statement
in ecpg application to call the stored procedures with IN or INOUT
params.

EXEC SQL CALL SP1(:hv1, :hv2);

Additionally, we can also use indicator variables along with the
arguments of stored procedure with CALL statement like shown below:

EXEC SQL CALL SP1(:hv1 :ind1, :hv2, :ind2);

The patch also adds some basic test-cases to verify if CALL statement
in ecpg can be used to call stored procedures with different type of
parameters.

Please have a look and let me know your thoughts.

Thank you.

-- 
With Regards,
Ashutosh Sharma
EnterpriseDB:http://www.enterprisedb.com

Вложения

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

Предыдущее
От: Vanil Mar
Дата:
Сообщение: Simulator; only modified postgresql optimizer
Следующее
От: Lukáš Sobotka
Дата:
Сообщение: Using COPY command in pqlib