Page 1 of 1

Sored procedure pamming failed

Posted: Wed 10 Feb 2010 12:00
by markaw
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!

Posted: Wed 10 Feb 2010 13:57
by AndreyR
Only primitive types are allowed to be used in Entity Framework.