ODP.NET Managed Driver Does Not Pull In PL/SQL Packaged Procedures And Functions (Doc ID 1914152.1)

Last updated on AUGUST 11, 2014

Applies to:

Oracle Data Provider for .NET - Version 12.1.0.1 and later
Information in this document applies to any platform.

Symptoms

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 4.121.1.0

Similar set-up with Unmanaged driver works fine.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms