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 -----------------------------------------------------------------