Anyone using TOAD for Oracle
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 !
[273 byte] By [
ulm_quest] at [2007-11-11 10:18:56]
# 1 Re: Anyone using TOAD for Oracle
See if the following helps:
http://www.oracle.com/technology/oramag/code/tips2003/113003.html
# 2 Re: Anyone using TOAD for Oracle
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/oramag/code/tips2003/113003.html
# 3 Re: Anyone using TOAD for Oracle
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
