Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Raptor: Viewing Package Body Source from different schema/user

69408Mar 8 2006 — edited Jun 7 2006
Hi,

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 5 2006
Added on Mar 8 2006
8 comments
1,571 views