Array Binding Using a RETURNING Clause Returns Wrong Results if an Error Occurs on the Insert/Update of a Row (Doc ID 1354064.1)

Last updated on DECEMBER 01, 2011

Applies to:

Oracle Data Provider for .NET - Version: 11.1.0.6 and later   [Release: 11.1 and later ]
Generic Windows

Symptoms

Using Array Binding to insert/update records with ODP.Net and the DML uses a RETURNING clause, if an error occurs on one row of the operation then the data in the returning clause will be wrong. The inserts/updates on the rows that contained no errors will complete successfully to the table but the results for the RETURNING clause will be incorrect.
Another issue also occurs from this scenario as well OracleCommand::ExecuteNonQuery()
is returning 0 rows even though rows have successfully been inserted and therefore it returns the wrong value as well.

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