ORA-04052: error occurred when looking up remote object

From: Paul Pratte <paul_pratte_at_umsl.edu>
Date: Tue, 09 Mar 1999 15:05:56 GMT
Message-ID: <7c3brn$cra@news.umsl.edu>

With Oracle 8.0.5 we get on all PL/SQL procedures that use remote links the following series of errors:
ORA-04052: error occurred when looking up remote object TEMP.TABLE_at_REMOTE.DBLINK.EDU
ORA-00604: error occurred at recursive SQL level 1 ORA-12154: TNS:could not resolve service name

If you do the query via SQL/PLUS it works. The entries that the dblink refers to are in the TNSNAMES.ORA file. These procedures work fine on a 7.2 system but fail when imported to the 8.0.5.

Any ideas? Received on Tue Mar 09 1999 - 09:05:56 CST