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 APRIL 09, 2020

Applies to:

Oracle Data Provider for .NET - Version and later
Generic Windows


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.




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

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