Devart Forums

Posted: **Tue 11 Oct 2011 08:57**

Hi Guys, I wanted to use EF 4.0 with oraDotconnect but when Im trying to map stored procedure Im getting this error:

The function 'EZMANAGERPKG.REMOVEMPFOREZ' has a parameter 'ATBL_MP' at parameter index 4 that has a data type 'TABLE' which is not supported. The function was excluded.

Can you help me with this one? I really need that sort of functionality - with passing array into stored proc.

Thanks in advance.

Posted: **Wed 12 Oct 2011 08:00**

dont use entity framework for this stored procedure, call it directly in code

Posted: **Wed 12 Oct 2011 15:10**

Refer to http://www.devart.com/dotconnect/oracle/docs/?EF.html, the Limitations section: "User-defined types, including Oracle objects, array types and nested tables are not supported."

Please use plain ADO.NET as wgkwvl suggested.

Devart Forums

How to pass Table into stored procedure

How to pass Table into stored procedure