30EA1 package bodies missing in schema browser still not fixed
516244Oct 27 2010 — edited Oct 29 2010This bug I was told would possibly be fixed in the upcoming version. I tried to track the bug but can not even find it in MOS.
Bug : 10034917 - PACKAGE BODIES MISSING IN SCHEMA BROWSER
My SR was 3-2032905951: SQL Developer Package tree not displaying all procedures/members.
The problem: While browsing the package using SQL Developer some of the user packages some or none of the members (procedures, functions) show up in the expandable package tree for the body. Also in the source of the package body on many of the user packages customer cannot expand/collapse the members on 10.1.2.4.0 database.
The cause that I have found to recreate the problem: used the quote operator in one of the package members.
Until this is resolved I would not be able to endorse using SQL Developer where I work and will continue to use TOAD as it does not have this problem. It also sound as if from the description of the bug above that it is intended to remove the feature of having members in a tree view. The feature is very useful when you have a package with 100 members in it. You can sort them by name or how they appear in the code, click on them and be taken directly to the member in the package body, etc... why remove it and say it was never intended to be that way?