Monday 21 August 2006

Oracle tip: Bulk binding exceptions

Our Oracle tip of the week, published at Techrepublic.com:



Handle bulk binding exceptions in PL/SQL



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.



No comments:

Post a Comment

Note: only a member of this blog may post a comment.