Hello All,
I am facing the problem of accessing procedure of remote server by creating synonyms, kindly help me.
1) Created DBLINK from Local DB to REMOTE DB.
2) Able access all the objects, except PROCEDURE.
3) Remote DB is having a Procedure PR1
4) From Local DB, we are accessing it by creating a SYNONYM SYN1
It was working fine suddenly showing such OBJECT is not existing.
We tried to recreate the synonym, it get created but showing the same error.
ORA-00942 table or view doesnt exist
ORA-02063: preceding line from (link name)
We confirmed the availablity of that PROCEDURE in the REMOTE DB.
Thanks and Regards
Muktha