Handle bulk binding exceptions in PL/SQL

August 22, 2006

[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