Error while calling proc with table type from Application

From: aditya desai <admad123(at)gmail(dot)com>
To: Pgsql Performance <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: Error while calling proc with table type from Application
Date: 2021-04-29 09:22:23
Message-ID: CAN0SRDFX79ZRcoY4SGKZH1yO3HcP4z8rjH9neOB1UCLcTXtdUA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Justin Pryzby 2021-04-29 13:02:36 Re: Error while calling proc with table type from Application (npgsql)
Previous Message Justin Pryzby 2021-04-29 04:24:04 Re: [PATCH] force_parallel_mode and GUC categories