unable viewing package body

[Harvey Kravis]

Hello, Can you explain why I cannot view a package body in another schema? I can view the package spec itself, but when I right-mouse on the package and choose View Spec and Body I can only see the package spec. The package body does not appear in the package folder either. Is this an Oracle thing or a PL/SQL Developer thing?

 

[Marco Kalter]

I assume the package is not owned by the connected Oracle user? 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 > Oracle / Options page) needs to be enabled as well.