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
Oracle Data Provider for .NET - Version: 18.104.22.168 and later [Release: 11.1 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.
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