PL/SQL Bulk Processing Checklist

Version 5

    To make it easier for developers to implement FORALL and BULK COLLECT in their code, especially when it comes to converting from "old-fashioned" row-by-row, I have created a checklist of key steps to take, and key issues to be aware of. For now, I offer a single-page checklist. As you will see in the comments below, this by no means cover all issues comprehensively. But it does offer a way to quickly check to make sure you are not missing anything really important. Over time, I hope to add more details behind each checklist item.

     

    In the meantime, I encourage our many Oracle Database development experts to add more comments to give depth to the checklist.