Handling Errors During Bulk DML Operations

29 Jan 2019
14:00 - 14:45

Handling Errors During Bulk DML Operations

Using bulk operations to do dml from plsql is a lot faster than processing row by row.
However, during bulk dml some or all records may not be successfully created, modified or deleted.
This presentation will be about some of the pitfalls in handling these errors using “save exception” and its alternative “log errors”.
Why is error_index a misleading name for that column in sql%bulk_exceptions? And how do you overcome the implications?
What if a record fails halfway through multiple consecutive bulk operations on relationally dependent tables?
Can log_errors be used as an alternative to using “save exceptions”?
You will be given the answers to these and more questions and gain a better understanding of how to deal with errors in bulk operations.