Oracle 7.3.4 - 8.1.7 - 9.2 link

From: Smith, Ron L. <rlsmith_at_kmg.com>
Date: Thu, 1 Jul 2004 15:21:29 -0500
Message-ID: <270A0BDDFDE54E41B78F0F06D82A66B8508C4F@okcexg3.kmg.com>

I am trying to set up a link between Oracle 7.3.4 and Oracle 9.2 by using an Oracle 8.1.7 database as a gateway.

I have created synonyms with dblinks pointing from the 7.3.4 db to the 8.1.7 gateway and then to the 9.2 database;

Selects on the tables work fine from the 7.3.4 and 8.1.7 database, but when I put the synonym in a procedure I get an hourglass and the procedure goes to never never land. Then it finally says it can't find the second link from 8.1.7 to 9.2.

I hope that is clear. Has anyone else tried this?

Ron Smith

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Thu Jul 01 2004 - 15:18:11 CDT