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.
vmachacek
 
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
wgkwvl
 
Posts: 39
Joined: Tue 20 Jul 2010 15:13

Postby 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.
Shalex
Devart Team
 
Posts: 7839
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle