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 18.104.22.168 and later
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