Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Packages - Debug info green icon is not properly refreshed

dz_rApr 8 2014

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.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 6 2014
Added on Apr 8 2014
0 comments
1,588 views