Problem Seeing Package Bodies

[Ian Barnett]

I am new to PL/SQL Developer. I installed version 6.04.906 and have an issue. I can't see the body of database packages, all I see are the package specs. These pacakges were not created by me but I should be able to see them. Other users with IDs that appear to have the same rights as me see the bodies.I looged in with a dba account and voila package bodies.

The part that puzzles me is if I log in with toad using my Oracle ID I can see the bodies.

Has anyone else experienced this issue? Am I missing permissions of is this a PL/SQL Dev problem?

Thanks,

Ian

 

[orca777]

Hi,
are you logged in at the owner of the packages?
if not you are not able to see the body if you have not enbaled the option in preferences/options

+ Use DBA-Views if abvailable.

if you have select privilege to the DBA-Views you can look at package bodies of other schemas which are not wrapped.
carl r.

 

[Ian Barnett]

Carl, that worked!! Thanks a lot. I spent way too much time trying to figure this out on my own before asking.

Thanks again,

Ian

Originally posted by orca777:
Hi,
are you logged in at the owner of the packages?
if not you are not able to see the body if you have not enbaled the option in preferences/options

+ Use DBA-Views if abvailable.

if you have select privilege to the DBA-Views you can look at package bodies of other schemas which are not wrapped.
carl r.