RE: Compile Procedure with Synonym/Dblink Oracle 9.2

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_at_gmail.com] 
	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_at_kmg.com> wrote: 

		They are both there and valid.
		
		

--
http://www.freelists.org/webpage/oracle-l