08-26-2014, 06:15 AM
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?