Sored procedure pamming failed

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
markaw
Posts: 13
Joined: Mon 11 Aug 2008 12:45

Sored procedure pamming failed

Post by markaw » Wed 10 Feb 2010 12:00

Hi,

I need to have a stored procedure in my EF. The stored procedure is defined as follows:
FUNCTION GetListID(pSys1 IN NUMBER, pA1 IN VARCHAR) RETURN PACKAGE_NAME.tNumber;

where

TYPE tNumber IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

I'm getting

warning 6005: The function 'GetListID' has a return data type 'PL/SQL TABLE' that is not supported, the function was excluded

any plan to support the PL/SQL TABLE?

Best regards!

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Wed 10 Feb 2010 13:57

Only primitive types are allowed to be used in Entity Framework.

Post Reply