Re: Is Package Information Stored in an ALL_* Table?

Brian Y. wrote:
>
> I would like to query the database for package information - namely the
> names of all the functions or procedures that are part of my package
> definition.
>
> For example, if I have a package...
>
> CREATE PACKAGE PKG1 AS...
>
> PROCEDURE update_names (...
> PROCEDURE update_appointments (...
> FUNCTION get_order_date (...
> etc.
> END PKG1;
>
> I would like to query for...
> update_names
> update_appointments
> get_order_date
> etc.
>
> Is there an ALL_ table that stores this information? Thanks in advance...
>
> B~

Take a look at ALL_ARGUMENTS

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"