RE: Compile Procedure with Synonym/Dblink Oracle 9.2
- From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
- To: <rlsmith@xxxxxxx>, "Igor Neyman" <ineyman@xxxxxxxxxxxxxx>, "Oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 8 Jul 2005 14:06:01 -0400
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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@xxxxxxxxxxxxxx]
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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.
--
//www.freelists.org/webpage/oracle-l
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.
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
