-
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 !
-
Paul
~~~~
Microsoft MVP (Visual Basic)
-
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
 Originally Posted by pclement
-
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
-
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
Similar Threads
-
By kathy in forum VB Classic
Replies: 3
Last Post: 04-11-2002, 07:28 AM
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Development Centers
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center
|