for table_name_v in table_list_c
ERROR at line 1:
ORA-04052: error occurred when looking up remote object
ORA-00604: error occurred at recursive SQL level 1
ORA-02068: following severe error from SCR_LINK
ORA-03113: end-of-file on communication channel
DB link(scr_link) is working properly & even the inner sql query when I run separately, it is working fine.
Please suggest what is going wrong here? What can I do to make it to work?
cursor table_list_c is
(select table_owner||'.'||table_name tab_name from scr_process@scr_link
where (owner||'.'||table_name ) not in(
select owner||'.'||table_name tab_name from dba_tables@scr_link