amar on web

• home
• On Oracle database
• On Oracle Forms&Reports
• On Oracle iAS
• On linux
• On PMP certification
• My blog
• My Profile
• family link

Allow me to hang and kill your SQL*Plus session

Database: Oracle 8i
Tool : Plus80w
This is not a destructive act, just something you need to know. Connect using Plus80w to a database. Make user that an object with the name of "amar" doesn't exist. Create a public synonym with the name of "amar". Now simply describe the object "amar" and see the after effects.

   On plus80w: 
   sql>connect scott/tiger@db01
   Connected. 

   sql>select object_name from user_objects where object_name = 'AMAR';
   no rows selected.

   sql>create public synonym amar for amar;
   synonym created.

   sql>desc amar

So why is describing "amar" hanging and killing your sql*plus session?

If it is not a feature, then it must be a bug. If a public synonym is created with the same name as the reference object and the reference object is not present, plus80w connected to oracle 8i hangs. The same works perfectly when connected from plus33w. Please note that oracle is supposed to display "Object does not exist." in such cases. Describing tables using db_link also throws error, though this will not hang your session.

      SQL>conn scott/tiger@db01
      connected. 
      sql>desc emp@db02 
      ERROR: 
      ORA-02019: connection description for remote database not found 

      SQL>select count(1) from emp@db02; 
        COUNT(1) 
      __________ 
              14 

Best viewed in medium text size. Please refresh this page (F5) to view the latest information.
This page was created on 15-dec-2000 and last updated on 15-dec-2000.
please forward all queries to amar_padhi@fastmail.fm