I have limited block size to < 64 K and <255 inserts. That creates several blocks to be executed in order to insert all the data.  I'm hesitant to execute them serially. Is it acceptable to enclose all the blocks inside a transaction that can be rolled back if a failure occurs later in the transaction?