Stored procedures which have array parameters

JSkibisky · 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:

TYPE array_ IS TABLE OF .%TYPE
INDEX BY BINARY_INTEGER;

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 !!

StanislavK · 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.