Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> ORA-02074 (Distrib txn error)
Hi,
We're implementing an oracle-based application which communicates with
an oracle-based 'off-the-shelf' package in a separate instance. The
two apps communicate over a DB link.
The 'off-the-shelf' app provides many stored procedures (effectively,
the app's API) which we have to access. Unfortunately (but
unsurprisingly) these SPs contain savepoints, commits and rollbacks.
Therefore, calling these remote SPs causes an "ORA-02074: cannot SET
SAVEPOINT in a distributed transaction" error.
We can't change the 'API' (remote) SPs, does anyone have any good
ideas on how to implement this?
I'm currently thinking of a separate schema on the 'client' DB
instance which contains the 'server' / 'API' SPs, with enough synonyms
set up in that schema so that
a) the 'API' SPs run in the parent session
b) the 'API' SPs are unchanged but do all of their work over the db
link.
I don't think this will be performant(!) but that's a low priority. Does anyone have a better solution?
thanks
=BILL SWIRE
EMAIL bill.swire_at_newsint.co.uk / bill_at_snitch.ltd.uk /
GSM +44.7973.253049
Received on Fri Feb 28 2003 - 06:58:44 CST