Array-Binding DML
We are trying to use the ODP array binding feature to issue DML (primarily inserts and updates). In the OCI world, when one of many DML statements fails, it is possible to find out which one it was by querying the error handle's offset. I do not see a corresponding value anywhere in the OracleException or OracleError objects. Is there any way to tell with ODP.NET? Otherwise, we are stumped as to the usefulness of this feature.
Many thanks,
Sebastian Good
Palladium Consulting Inc.
---
http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/appdev.920/a96584.pdf
page 175.
The oci layer attempts to process all rows in an array bound execution. Offending rows produce an error handle which contains the cause of the exception and the offset to the row. The old 6-7x behavior was to throw an exception at the first offending row in an array insert. The rows processed attribute would indicate the row that caused the problem.