Hi everyone,

The system I'm working on has two separate DBs (one Oracle and another separate proprietary system).

In one specific operation, I need to store results in one DB and update the status in another. I want to establish a transaction so that if one of the two operations fails, I can do a roll-back of the whole operation... I think you get the picture...

Can it be done; of course, without having to program all the custom transaction related code? ;)

Joel