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"
Received on Wed Apr 09 2003 - 10:11:22 CDT
