Stored procedures which have array parameters

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
Posts: 2
Joined: Wed 16 Jun 2010 16:17

Stored procedures which have array parameters

Post by JSkibisky » Wed 16 Jun 2010 16:29

I'm attepting to add a stored procedure to an EF4 entity model. This particular procedure has a number of parameters that are arrays. They are defined as:


Please note that I'm replacing some actual code with a generic value in the code examples.

When attepting to include this procedure in the model, the designer identifies the following error(s)

"The function . has a parameter 'IN_' at parameter index nn that has a data type 'PL/SQL TABLE' which is not supported. The function was excluded."

I did read the FAQ page, but it it doesn't clearly state what to do regarding this issue. What is the workaround... if any... for this?

Thanks !!

Devart Team
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Post by StanislavK » Fri 18 Jun 2010 13:19

The problem is that user-defined types, including table types, cannot be supported in Entity Framework. Unfortunately, there is no workaround for this.

Post Reply