Question: use DBA Views if available

[ScottMattes]

What does PL/SQL need to be able to show me the package body owned by another schema?

I can do a SQL to see the contents as found in DBA_SOURCE, but even though I have 'Use DBA Views if availble' checked PL/SQL Dev does not show me the body.

Thank you.

 

[Marco Kalter]

You will also need select privileges on the SYS.DBA_OBJECTS view.