ODP.NET Managed DataAdapter MissingSchemaAction.Ignore Property Doesn't Work as Expected

(Doc ID 2267455.1)

Last updated on MAY 22, 2017

Applies to:

Oracle Data Provider for .NET - Version 12.1.0.2 and later
Microsoft Windows x64 (64-bit)
Microsoft Windows (32-bit)

Symptoms

MissingSchemaAction property should take effect when existing DataSet schema does not match with incoming data. Ignore member from MissingSchemaAction should ignore the extra columns from the DataSet. But while using ODP.NET Managed driver it throws an exception. Same code works fine with Unmanaged ODP.NET provider.

Issue can be reproduced using the below code.

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