Re: How to get text of a stored package?

In article <3B4F57D2.7FB05E20_at_attws.com>, "Daniel says...
>
>Art Shen wrote:
>
>> Thanks everyone. But the thing is I don't have DBA privilege , and the
>> xxx_source only display the defination of the package, not the
>> detail(package body) of each procedures within that package. I need to know
>> the detail message of the those procedures and functions.
>>
>> Art
>>

 ..... snip .....
>
>Go to http://www.quest.com.
>
>Download a trial version of TOAD or SQL Navigator. Install it. Grab your code.
>Remove the software after the trial period is over unless you like it and have
>sufficient budget.
>
>Daniel A. Morgan
>

And then what?

Toad and SQL Navigator won't let you see what Oracle won't let you see.

He either needs:

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