RE: Oracle 7.3.4 - 8.1.7 - 9.2 link

  • From: "Smith, Ron L." <rlsmith@xxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 2 Jul 2004 07:48:19 -0500

Subject: Oracle 7.3.4 - 8.1.7 - 9.2 link


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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: