Can't see package body in plsql/developer

[ukchucktown]

I can't seem to view package bodies inside pl/sql developer. I can extract the DDL and view it inside other tools, specifically the MyEclipse DB browser, but I've had no luck viewing the package body in pl/sql developer. I don't have any browser filters enabled that would hide package bodies so I'm wondering what else to check. I can see the package declaration in pl/sql developer, just not the package body.

Grant

 

[rbrooker]

when you right click on a package, do you specify "view spec and body" or do you select "view"?

 

[ukchucktown]

I did select "view spec and body" in the popup menu.

Grant

 

[Worker]

In a PL/SQL Developer SQL window, run the query:

select distinct owner, name from all_source where type = 'PACKAGE BODY'

Does that list include the packages you think you should be able to see?

 

[Marco Kalter]

Another user's package bodies will only be visible if you have select privileges on the sys.dba_objects and sys.dba_source views. The "Use DBA views if available" preference (Tools > Preferences > Options tab page) needs to be enabled though.

 

[ukchucktown]

I do have select privileges on the dba_objects and dba_source views. Setting the flag in the preferences did the trick. I did not have it enabled.

Thanks,

Grant

 

[Marcel de Boer]

Was looking for this for quite some time! It still does the trick! Thanks for the solution!