ODP.NET Managed Driver Does Not Pull In PL/SQL Packaged Procedures And Functions
Last updated on AUGUST 11, 2014
Applies to:Oracle Data Provider for .NET - Version 126.96.36.199 and later
Information in this document applies to any platform.
While building an ADO.NET Entity Data Model using update model from database, PL/SQL procedures and functions that are stored within a package are not brought into the model and cannot be seen from the model browser. This scenario forces users to choose non-package based procedures and functions individually to bring them to the model.
The issue occurs with the below environment
Visual Studio 2012
Entity Framework 5.0.0
ODP.NET Managed Driver version 188.8.131.52
Similar set-up with Unmanaged driver works fine.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms