Anyone using TOAD for Oracle


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 5 of 5

Thread: Anyone using TOAD for Oracle

  1. #1
    Join Date
    Dec 2006
    Posts
    4

    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 !

  2. #2
    Join Date
    Dec 2003
    Posts
    2,750
    Paul
    ~~~~
    Microsoft MVP (Visual Basic)

  3. #3
    Join Date
    Dec 2006
    Posts
    4
    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

    Quote Originally Posted by pclement

  4. #4
    Join Date
    Jan 2007
    Posts
    5
    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

  5. #5
    Join Date
    Nov 2017
    Posts
    1
    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

  1. any suggestions in using TOAD
    By kathy in forum VB Classic
    Replies: 3
    Last Post: 04-11-2002, 08: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
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center