Handling errors during bulk DML operations
Track
Database & Infrastructure
Date and time
Wednesday, 12. October 2022., 15:25
Room
Hall B
Duration
45'
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
About speaker
Erik van Roon, author
Erik van Roon is an Oracle Database Developer and Oracle ACE Pro, who has worked with Oracle technology since 1995, specializing in, but not limiting to, SQL and PLSQL. Since 2009 he is self-employed. His company is called EvROCS. Prior to that he has worked for several consulting companies in the Netherlands.He has worked on major projects for several clients in industries like entertainment, banking and energy.Erik has been the technical lead of multiple successful high impact data-migration projects moving and transforming large amounts of data.He's been a speaker at many conferences in Europe and the United states.He is a board member of community support program Symposium42 (https://sym42.org/), and is a co-founder and core member of the MASH program which mentors new speakers during their first steps as a speaker.