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 -- //www.freelists.org/webpage/oracle-l