How to pass Table into stored procedure

How to pass Table into stored procedure

Postby 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.
Posts: 4
Joined: Mon 12 Sep 2011 08:59

Postby wgkwvl » Wed 12 Oct 2011 08:00

dont use entity framework for this stored procedure, call it directly in code
Posts: 39
Joined: Tue 20 Jul 2010 15:13

Postby Shalex » Wed 12 Oct 2011 15:10

Refer to, 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 Team
Posts: 7945
Joined: Thu 14 Aug 2008 12:44

Return to dotConnect for Oracle