More ways to prevent a single unusable value breaking your entire statement Database concepts Add comments Dec 172012 Click the image for copy-pastable scripts. Hat tip to Tom Kyte for showing that you can process the sql%bulk_exceptions in a separate procedure without having to pass it as parameters. Get SQLfail sent to your inbox Share this:FacebookGoogleTwitter select posts from sqlfail where content like :this_post; -20001: An Oracle Exception Odyssey More fun with nulls and (bitmap) indexes Upsert method 3: The set based approach Upsert method 2: When you expect to mostly be updating existing data Who’s NO_DATA_FOUND is it anyway? Leave a Reply Cancel reply Name (required) E-mail (required) URI Your Comment You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> Notify me of follow-up comments by email. Notify me of new posts by email.