Home » SQL & PL/SQL » SQL & PL/SQL » PL/SQL: ORA-04052: error occurred when looking up remote object (Oracle 9i)
PL/SQL: ORA-04052: error occurred when looking up remote object [message #335220] Mon, 21 July 2008 08:56 Go to next message
atozvs
Messages: 12
Registered: May 2008
Location: Hyderabad
Junior Member
Hi,

I have a SP which was running successfully, but after some DB migration from 9i to 10g byDB team i started to get the following error.

PL/SQL: ORA-04052: error occurred when looking up remote object WGR_QRY.<Proc_name>@<DB>.US.ORACLE.COM
ORA-00604: error occurred at recursive SQL level 1

Thanks

Regards
Vidya
Re: PL/SQL: ORA-04052: error occurred when looking up remote object [message #335224 is a reply to message #335220] Mon, 21 July 2008 09:03 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
ORA-04052: error occurred when looking up remote object %s%s%s%s%s
 *Cause:  An error has occurred when trying to look up a remote object.
 *Action: Fix the error.  Make sure the remote database system has run
          KGLR.SQL to create necessary views used for querying/looking up
          objects stored in the database.

Regards
Michel
Re: PL/SQL: ORA-04052: error occurred when looking up remote object [message #335226 is a reply to message #335220] Mon, 21 July 2008 09:04 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow the Posting Guidelines as stated in URL above
Previous Topic: How to select oracle sequence from different schema
Next Topic: How to implement PHP sprintf in PL/SQL
Goto Forum:
  


Current Time: Fri Feb 14 16:34:48 CST 2025