RE: Compile Procedure with Synonym/Dblink Oracle 9.2

From: Mercadante, Thomas F (LABOR) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Fri, 8 Jul 2005 14:06:01 -0400
Message-ID: <ABB9D76E187C5146AB5683F5A07336FF35F9F4@EXCNYSM0A1AJ.nysemail.nyenet>

You may need to drop and recreate the synonym. Did the remote object get dropped and recreated? The synonym is probably pointing to the prior object.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Smith, Ron L. Sent: Friday, July 08, 2005 2:04 PM
To: Igor Neyman; Oracle-l
Subject: RE: Compile Procedure with Synonym/Dblink Oracle 9.2

They are both there and valid.

-----Original Message-----

From: Igor Neyman [mailto:ineyman_at_perceptron.com] Sent: Friday, July 08, 2005 12:51 PM
To: Smith, Ron L.; Oracle-l
Subject: RE: Compile Procedure with Synonym/Dblink Oracle 9.2

Obviously, it's complaining about absence of Synonym/dblink during compile time. Either have your Synonym/dblink valid at compile time, Or, If it's not possible (Synonym/dblink exists only at "execution" time) - use dynamic sql (i.e. "execute immediate...") for sql statements referencing Synonym/dblink.

Igor

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Smith, Ron L. Sent: Friday, July 08, 2005 1:43 PM
To: Oracle-l
Subject: Compile Procedure with Synonym/Dblink Oracle 9.2

I am trying to compile a procedure that contains a synonym pointing to another database. I am getting an error ORA-00980 Synonym translation is no longer valid.

Is there an easy way around this?

Thanks!
Ron

Important Notice!!
If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you.
--

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