Re: Oracle Distributed Transactions

From: Ed Prochak <edprochak_at_adelphia.net>
Date: Wed, 09 Apr 2003 17:28:38 GMT
Message-ID: <3E945C30.4050202@adelphia.net>

Volker Hetzer wrote:
> Sybrand Bakker wrote:
>

>>On 8 Apr 2003 05:09:03 -0700, karen.mcdonagh_at_singularity.co.uk (Karen)
>>wrote:
>>
>>>set transaction read write
>>>   insert into a remote table via a DB Link - This should succeed
>>>   insert into a remote table via a DB Link - This should fail
>>>commit;
>>
>>Rollback due to error is *always* and has been since release 6
>>*statement* level rollback. So nothing is wrong, if you require the
>>transaction to be rolled back you need appropiate exception handling.

>
> So you mean, in case of error the applicaiton should say "rollback" in
> order to rollback the first insert too?
>
> Greetings!
> Volker
> --
> While it is a known fact that programmers
> never make mistakes, it is still a good idea
> to humor the users by checking for errors at
> critical points in your program.
> -Robert D. Schneider, "Optimizing INFORMIX
> Applications"
>
>
>

Yes.

Nice quote BTW.

-- 
Ed Prochak
running    http://www.faqs.org/faqs/running-faq/
netiquette http://www.psg.com/emily.html
--
"Two roads diverged in a wood and I
I took the one less travelled by
and that has made all the difference."
robert frost

Received on Wed Apr 09 2003 - 12:28:38 CDT