Handling errors during bulk DML operations


Database & Infrastructure

Date and time

Wednesday, 12. October 2022., 15:25


Hall B



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.

Lecture details

Talk Attendence: Attendance in person
Level of difficulty: General
Desirable listeners function: Developers
Group of activity: Database & Infrastructure

About speaker