How to pass Table into stored procedure

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
vmachacek
Posts: 4
Joined: Mon 12 Sep 2011 08:59

How to pass Table into stored procedure

Post by vmachacek » 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:

Code: Select all

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.

wgkwvl
Posts: 39
Joined: Tue 20 Jul 2010 15:13

Post by wgkwvl » Wed 12 Oct 2011 08:00

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

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » 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.

Post Reply