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

Other related posts: