Handle bulk binding exceptions in PL/SQL

Tuesday Aug 22nd 2006 by DatabaseJournal.com Staff

The downside to bulk binding in PL/SQL is that if any of the data values result in an invalid UPDATE, the entire set of iterations is rolled back. Bob Watkins explains how you can get around this issue.

[From Builder.com]

Bulk binding in PL/SQL is an important technique for efficient processing of dynamic DML. Instead of looping within your program, and submitting one UPDATE statement with each iteration, you use the FORALL statement to submit a single UPDATE statement with bind variables in it. Collections, such as nested tables or VARRAYs, are used to pass multiple data values to the bind variables.

The article continues at http://builder.com.com/5100-6388_14-6107789.html?tag=sc

Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved