ODP.NET Managed DataAdapter MissingSchemaAction.Ignore Property Doesn't Work as Expected
Last updated on MAY 22, 2017
Applies to:Oracle Data Provider for .NET - Version 18.104.22.168 and later
Microsoft Windows x64 (64-bit)
Microsoft Windows (32-bit)
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.
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