My Oracle Support Banner

Merge Using Array Bind Fails With Managed ODP (Doc ID 1901048.1)

Last updated on JUNE 25, 2014

Applies to:

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

Symptoms

Merge using the array bind works fine with un-managed ODP.NET 11.2.0.3 and 12.1.0.1 but the same code doesn't work with Managed ODP 12.1.0.1. Sample Code attached to the Note.

SQLPLUS Output

SQL> select * from ttest;

        ID NAME      VALUE
---------- ---- ----------
         1 aa           30
         2 bb           40
         3 cc           50
         4 dd           60
         5 ee           70

Un-managed Output

SQL> select * from ttest;

        ID NAME      VALUE
---------- ---- ----------
         1 a           1.1
         2 b           2.1
         3 c           3.1
         4 d           4.1
         5 e           5.1

Managed Output

SQL> select * from ttest;

        ID NAME      VALUE
---------- ---- ----------
         1 a           1.1
         2 b           2.1
         3 cc           50
         4 dd           60
         5 ee           70

 

Changes

Swiching the provider from un-managed ODP (Oracle.DataAccess.dll) to Managed ODP(Oracle.ManagedDataAccess.dll)

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.