View package body and trigger code

[YSR]

I am able to see code in procedures, functions and package specification but not able to see code in 'package body' and 'trigger'. When I try to expand trigger or package body in 'browser tree', I do not see any objects. I am also not able to see these two types in all_source. Can you please let me know if there is specific role that needs to be granted ? I have SELECT_ANY_CATALOG granted to my userid. Please help.

 

[Marco Kalter]

Perhaps you need to enable the "User DBA views if available" option (Tools > Preferences > Oracle / Options)?