0 Replies Latest reply: Apr 8, 2014 4:38 AM by dz_r RSS

    Packages - Debug info green icon is not properly refreshed

    dz_r

      Latest version of SQL Developer (4.0.1.14), database 10g (10.2.0.4).

       

      1. I'm expanding the "Packages" node in the tree navigator

      2. If there are no packages compiled with debug info (with green bug icon), then You should compile some with debug and restart SQL Developer and expand the "Packages" node again

      3. I can check by the following SQL that at the moment there are some packages compiled with debug info:

       

      SELECT

      OWNER, OBJECT_NAME, OBJECT_TYPE, DEBUGINFO, STATUS

      FROM

      SYS.ALL_PROBE_OBJECTS

      WHERE

      OBJECT_TYPE IN ('PACKAGE', 'PACKAGE BODY') AND OWNER = :OWNER

      ORDER BY

      OWNER, OBJECT_NAME, OBJECT_TYPE

      ;

       

      4. Now I'm right-clicking the "Packages" node and selecting the "Compile All" function.

      After that all the packages are compiled without debug info (SQL above confirms that) but all green bug icons are still visible in the navigator.

      Refreshing node "Packages" or reconnecting DB doesn't help.

      Only restarting SQL Developer helps - there are no more green bug icons in the "Packages"node.