Re: How to get text of a stored package?

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Sat, 21 Jul 2001 21:36:49 GMT
Message-ID: <9inn4602rc3@drn.newsguy.com>

In article <gVF37.154004$W02.2678374_at_news1.rdc2.on.home.com>, "Art says...
>
>Hi all,
>
>I can only get the text of a procedure or head of package from all_source.
>How can I get a full content of package body?
>Oracle 7.3.4
>
>
>Thanks
>
>

You either need:

o access to DBA_SOURCE. Your DBA can grant you select on just that view.

o CREATE ANY PROCEDURE to see package bodies, or EXECUTE|CREATE ANY PROCEDURE to see standalong procedures/functions in ALL_SOURCE

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp

Received on Sat Jul 21 2001 - 16:36:49 CDT