My Oracle Support Banner

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 FEBRUARY 19, 2019

Applies to:

Oracle Data Provider for .NET - Version 11.1.0.6 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.

Changes

 

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.