viewing source code from PROD

[cmatta]

Hi,
I am a new user to PL/SQL Developer.Earlier I used to use TOAD for my development.

Question is: How can I view source code of any PL/SQL object in a READ ONLY instance.

I have READ ONLY access to my PROD database. Were I can query tables data, view all the objects etc.

But I am not able to browse and view any pl/sql objects.
What is the work around for this ?

one way is - all_source table.

Thanks

 

[Marco Kalter]

Maybe you need to enable the "Use DBA views" preference (Tools > Preferences > Oracle / Options)?

 

[William Robertson]

Perhaps you need to set the object browser filter (at the top of the object navigator)? Maybe it's set to 'Current User'.

 

[cmatta]

It works. Thanks