Devart Forums

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

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