Re: transaction error handling

[Bèrto ëd Sèra <berto.d.sera@xxxxxxxxx>]

On 29 November 2011 21:34, Rob Richardson <RDRichardson@xxxxxxxxxxx> wrote:

If Oracle saves half of the data  between the beginning and ending of the transaction, doesn't that defeat the purpose of the transaction?

 

It sure enough kills Atomicity. I can see a use for this on importing data from external sources that may violate existing unique keys, so illegal inserts are ignored, but you still are left without any knowledge of what rows where silently dropped. Since when is Oracle doing this, FMI? (It's been a long while since I used it for anything serious)

Bèrto

-- 
==============================
If Pac-Man had affected us as kids, we'd all be running around in a darkened room munching pills and listening to repetitive music.