Package body not show

[juhiati]

Hi,

I changed from version 9 to 13 and now when I click on package name -> View Spec&Body only the Spec shown. There is any option for this behavior on Preferencies?
Thx

 

[Marco Kalter]

If the type body is owned by another user you will need to:

1. Enable the "Use DBA views if available" option (Preferences > Oracle / Options).

2. Obtain select privileges on the DBA_OBJECTS and DBA_SOURCE views.