Re: Merge from pl/sql table

Leon wrote:
> 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

I'm not sure how you relate a FOR loop to data integrity. I see them as having no relationship with each other.

Rarely if ever do I use FOR loops given the high cost of single-row processing. And not once has it caused me data integrity concerns.

Could you please provide more information or sample code so we can see what the issue is? Also the Oracle version number.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org