Home » RDBMS Server » Networking and Gateways » Synonyms for Remote DB (oracle 12.1.0.1)
Synonyms for Remote DB [message #682800] Fri, 20 November 2020 08:59 Go to next message
muktha_22
Messages: 527
Registered: December 2009
Senior Member
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
Re: Synonyms for Remote DB [message #682801 is a reply to message #682800] Fri, 20 November 2020 09:10 Go to previous messageGo to next message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
Can you debug code you cannot see?
I think everyone here speaks SQL. Show us your SQL for 1) creating the db link, 2) creating the synonym, 3) your actual statement that produced the error.
Re: Synonyms for Remote DB [message #682803 is a reply to message #682800] Fri, 20 November 2020 09:49 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
You don't get ORA-00942 table or view doesnt exist from "missing" Procedure.
It appears that you are mis-reporting reality.

use COPY & PASTE so we can see what you do & hw Oracle responds.
Previous Topic: Oracle Net proxy
Next Topic: Connection to MS SQL using ODBC Gateway
Goto Forum:
  


Current Time: Thu Mar 28 18:01:08 CDT 2024