Error while calling proc with table type from Application

Поиск
Список
Период
Сортировка
От aditya desai
Тема Error while calling proc with table type from Application
Дата
Msg-id CAN0SRDFX79ZRcoY4SGKZH1yO3HcP4z8rjH9neOB1UCLcTXtdUA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Error while calling proc with table type from Application (npgsql)
Список pgsql-performance
Дерево обсуждения
Hi,
One of the procs which accept tabletype as parameter gives below error while being called from Application. Could not find a concrete solution for this. Can someone help?

call PROCEDURE ABC (p_optiontable optiontype)

 

Below is the error while executing proc -

“the clr type system.data.datatable isn't natively supported by npgsql or your postgresql. to use it with a postgresql composite you need to specify datatypename or to map it, please refer to the documentation.”


Regards,

Aditya.

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

Предыдущее
От: Jean-Christophe Boggio
Дата:
Сообщение: Re: Order of execution
Следующее
От: Justin Pryzby
Дата:
Сообщение: Re: Error while calling proc with table type from Application (npgsql)