Oracle Forums Community of Oracle Professionals including Fusion/Cloud Application Consultants, ERP Experts, Oracle Apps Functional Consultants, Apps DBAs, DBAs, Cloud DBAs, Technical Consultants, Fusion Middleware Experts, SQL, PL/SQL Developers and Project Managers. Welcome to Social Community, a friendly and active community of Oracle Technology Professionals who believe that technology can ‘make the world a better place’. By joining Oracle ERP Community you will have the ability to Post Topics, Receive our Newsletter, subscribe to threads and access many other special features. Registration is Quick and Simple.
Get unlimited access to Oracle Tutorials, Articles, eBooks, Tools and Tips by upgrading to "Premium Membership".
Oracle Training

Thread Rating:
  • 31 Vote(s) - 2.97 Average
  • 1
  • 2
  • 3
  • 4
  • 5
ORA-04052: error occurred when looking up remote object
I have created a function in which a table is accessed through the database link
when I compile it shows the following error:

ORA-04052: error occurred when looking up remote object abc_OWNER.ALL_TAB_COLUMNS@db_abc_LINK
ORA-00604: error occurred at recursive SQL level 1
ORA-12170: TNS:Connect timeout occurred

Can anyone help?
Thanks given by:
The major reason is due to invalid dblink, suggestion is to re-create db link by following proper method.
if you will still face issue, search on my support there are number of notes available to address these type of issues.
Thanks given by:

Possibly Related Threads...
Thread Author Replies Views Last Post
  oracle database 12c installation error Ahmad Mujeeb 0 738 12-12-2014, 01:24 AM
Last Post: Ahmad Mujeeb
  ORA-01722: invalid number - Error during implicit conversion Hassan Habib 1 879 12-12-2014, 01:14 AM
Last Post: Ahmad Mujeeb
  ORA-00600: internal error code, arguments: [17182] - adding standby database to broke Pryia Rai 1 1,871 12-11-2014, 04:03 PM
Last Post: Hassan Habib
  How to Troubleshoot ORA-600 Ali Rizwan 1 594 12-11-2014, 03:45 PM
Last Post: Hassan Habib
  Oracle error messages Pryia Rai 0 1,006 08-28-2014, 03:45 AM
Last Post: Pryia Rai
  ORA-00439: feature not enabled: Managed Standby Richard 1 3,037 02-17-2013, 02:46 PM
Last Post: Kashif Manzoor

Users browsing this thread: 1 Guest(s)
Get Premium Membership Get Oracle Tutorials, Tips! Post a Question!