Home » SQL & PL/SQL » SQL & PL/SQL » How do I view the package's body
How do I view the package's body [message #323510] Wed, 28 May 2008 11:26 Go to next message
gecs
Messages: 5
Registered: December 2007
Location: Lima
Junior Member

Hi, everybody. Someone knows some query allow me view the content of a package?? is necesary to do any configuration or have any permits, attributes??... Thanks....
Re: How do I view the package's body [message #323515 is a reply to message #323510] Wed, 28 May 2008 11:31 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
query dba|all|user_source
Re: How do I view the package's body [message #323516 is a reply to message #323510] Wed, 28 May 2008 11:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can see your code not other one unless you have high privilege.

Regards
Michel
Re: How do I view the package's body [message #323522 is a reply to message #323516] Wed, 28 May 2008 11:48 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Having the EXECUTE privilege on a package will let you see the packahe header. You need ALTER ANY PROCEDURE to view any package body (If I remember correctly, which is far from guaranteed)
Re: How do I view the package's body [message #323527 is a reply to message #323522] Wed, 28 May 2008 12:21 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
I believe you have access to all code via dba_source (including package bodies). SELECT_CATALOG_ROLE is a common way to gain access to dba_* views.
Re: How do I view the package's body [message #323530 is a reply to message #323522] Wed, 28 May 2008 12:23 Go to previous message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is CREATE ANY PROCEDURE or DEBUG ANY PROCEDURE and I call them high level privilege.

Regards
Michel
Previous Topic: Error in procedure when called
Next Topic: Showing right values with max function
Goto Forum:
  


Current Time: Wed Dec 07 12:51:37 CST 2016

Total time taken to generate the page: 0.29216 seconds