The synonym/link points from a 9.2 database, which points to a synonym/link in a 8.1.7 database, which points to a table in a 7.3.4 database. I found that if I create the tables in the 9.2 database, I can get the proc to compile. Then I delete the tables which leaves the synonym/link. The proc stays valid and runs as it should. Jumping through hoops, but what else can you do with legacy systems? Ron -----Original Message----- From: Jared Still [mailto:jkstill@xxxxxxxxx] Sent: Friday, July 08, 2005 1:13 PM To: Smith, Ron L. Cc: Oracle-l Subject: Re: Compile Procedure with Synonym/Dblink Oracle 9.2 Ron, Can you create a small test case for this? That will validate whether or not you are able to compile a procedure that uses a synonym with dblink. If that succeeds, you need to then determine why the other procedure is failing. A bug perhaps. -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist On 7/8/05, Smith, Ron L. <rlsmith@xxxxxxx> wrote: They are both there and valid.