Merge from pl/sql table

I have a master/detail transaction. Is there any other way of doing transaction processing than in a for loop, which ensures data integrity. I need to be able to process a complete transaction of fail a complete transaction. I have been thinking of processing/validating all my transactions and placing valid transactions in a pl/sql table. Once complete doing a merge into the transaction tables from the pl/sql table. Is this possible.

tks Received on Wed Jun 14 2006 - 01:31:22 CDT