Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-02074 (Distrib txn error)

Re: ORA-02074 (Distrib txn error)

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Fri, 28 Feb 2003 09:00:22 -0800
Message-ID: <3E5F95A6.96A2866B@exesolutions.com>


Bill Swire wrote:

> 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
Assuming you didn't steal the software ... I'd call the vendor and put their feet to the fire.

And if you would be so kind as to help others ... please name names.

Daniel Morgan Received on Fri Feb 28 2003 - 11:00:22 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US