Anyone using TOAD for Oracle

[ulm_quest]

Hello,
Can anyone plz help me. I am facing this problem while procedures creation in TOAd. When i create procedures and compile it, i get this error:
ORA-00980: synonym translation is no longer valid

I am using Oracle 9i.

Plz Help !

[pclement]

See if the following helps:

http://www.oracle.com/technology/ora...03/113003.html

[ulm_quest]

Hello,
I read ur reply for the error: "ORA-00980: synonym translation is no
longer valid"
I am using Toad 8.6 for oracle. Oracle 9i.
I simply created new table and then created a procedure to insert
value in tht table. I didn't create any synonym.
Secondly when i compile and execute this procedure in SQL *Plus, it
works absolutely fine. But in Toad interface it gives the error

error: ORA-00980: synonym translation is no longer valid
I have tried doing it so many times, everytime with new table name and
procedure name.
Can't find where i am wrong. Plz Help

See if the following helps:

http://www.oracle.com/technology/ora...03/113003.html

[Michael Raven]

I am using Toad 8.6 too but on Oracle 10g
can't reproduce your error while creating SP either synonym - it all OK
what syntax are you using in *Plus?
try other mngmnt tools like http://www.sqlmanager.net/en/products/oracle/manager

[Tom_Johnson]

I can advice you dbForge Studio for Oracle, a powerful Oracle GUI that helps to increase PL/SQL coding speed, provides versatile data editing tools for managing in-database and external data, allows synchronizing data between different Oracle servers and automating schema change management process during development. More information at https://www.devart.com/dbforge/oracle/studio/features.html