FAQ
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
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. wrote:

They are both there and valid.

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

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 7 of 8 | next ›
Discussion Overview
grouporacle-l @
categoriesoracle
postedJul 8, '05 at 12:45p
activeJul 8, '05 at 1:30p
posts8
users5
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase