Oracle - Is it possible to maintain transaction across multiple schemas?
yes you can, just be sure that the transactions are defined by the uppper layer - the client. A transaction has to be Atomic, so has to succeed (and commit) or has to fail (and rollback).