Distributed Transactions and ORA-2074
I have a database that has two schemas. I am trying to seperate those two schemas so each resides in their own database. SchemaA uses SchemaB's data by calling methods in a package owned by SchemaB. While the data is manipulated by SchemaB's package, SchemaA controlls the transaction. When both schemas are on the same database all works fine.
However, when I copy SchemaA to another database, we find that SchemaB has declared SAVEPOINTs in his code. While SchemaA continues to control the transaction, he encounters an ORA-2704 (cannot SET SAVEPOINT in a distributed transaction) error when calling SchemaB's packages.
I can conceptually see why we wouldn't want to do this, but to minimize changes, is there any way around this?