Raptor: Viewing Package Body Source from different schema/user
69408Mar 8 2006 — edited Jun 7 2006Hi,
In the development environment, there is a need to view Package Body for Packages created in a different schema. The user who wants to view the package body source from different schema has the execute privilege on it and select privilege on all DBA_ Views.
I know that the package body source can be viewed using DBA_SOURCE package.
In Raptor or "Oracle SQL Developer", I can only see the package specs but NOT the source for package body under "Other Users". Am I missing something here or is it intentional? Most of the other PLSQL IDE Tools (Toad/SQl Navigator etc.) display package body source code for packages under from different schema.
Thanks in Advance