Viewing a Procedure

Hi,

I was wondering if anyone could tell me how i can get a copy of a procedure i.e.
I want a copy of the procedure STATSPACK.STAT_CHANGES
I have queried ALL_SOURCE but cant work out how to specifically select the STAT_CHANGES part so I can spool and save it to a file.

Any advice much appreciated....

how about try dba_source

The source of the mentioned procedure will be available at the
%oracle_home/rdbms/admin/spcpkg.sql

Using OEM/TOAD are some of the ways of extracting the source

Hi Thanks for info
I found the source in %oracle_home/rdbms/admin/spcpkg.sql

Thanks again

Shandy