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

Hello,

Try

Select * from all_source where upper(text) like 'UPDATE_NAMES';

Greetings,

Peter.

"Brian Y." <NOSP_at_M> wrote in message
news:W45b6.3843$mo2.443408_at_news1.news.adelphia.net...
> 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~
>
>
Received on Tue Jan 23 2001 - 02:20:52 CST