title: ORA-04052: error occurred when looking up remote object OWNER.FUNCTION_NAME@DB_LINK Oracle 11g to 10g
body: <p>I'm running an oracle 11g database that needs to run queries on a remote Oracle 10g database. To do this I created a database link on my 11g system. The link works fine with ordinary SQL queries. 
  E.g: SELECT * FROM table_name@db_link work fine.</p>
  
  <p>However, when I attempt to execute a procedure residing on the 10g system from the 11g, I get the following error:</p>
  
  <p>ORA-04052: error occurred when looking up remote object OWNER_NAME.FUNCTION_NAME@DB_LINK
  ORA-00604: error occurred at recursive SQL level 1
  ORA-06544: PL/SQL: internal error, arguments: [55916], [], [], [], [], [], [], []
  ORA-06553: PLS-801: internal error [55916]
  ORA-02063: preceding 2 lines from DB_LINK</p>
  
  <p>The procedure is executed by the use of synonyms, I'm using PL/SQL Developer.</p>
  
  <p>The 11g system is on Windows 7 while the 10g is on Solaris, if it's of any relevance.</p>