Viewing Objects in Allround PL/SQL Developer

raam94

Member
I am experiencing an issue in Allround PL/SQL Developer (Version 16.0.3.2156 (64 bit)) where I can only see tables and views, but not packages, functions, or procedures. The tool only displays system-defined functions and procedures, while user-defined ones are not visible.
However, when I use SQL Developer, I can see all objects, including packages, procedures, and functions.

What can be the problem? Is there an option to enable the display?
Thanks
 
The object selection is controlled by 3 fields above the Object Browser. From top to bottom:

1. The selected user (by default "current user")
2. The selected filter (by default "all objects")
3. A custom filter expression (by default empty)

Make sure that these selection fields do not exclude the missing objects.

Also note that the Object Browser fetches information from the ALL_OBJECTS view by default. To fetch from the DBA_OBJECTS view instead, go to Preferences > Oracle > Options and enable the "Use DBA views if available" option. Restart PL/SQL Developer and check if this helps.
 
Back
Top