Re: retrieving package name

in sqlplus describe <schema>.package_name This will return all procedures and functions in a package.

If you want a list of all packages:

select object_name
from all_objects
where object_type = 'PACKAGE';

For just your packages
select object_name
from user_objects
where object_type = 'PACKAGE';

--
Robert P. Lockard
rob_at_oraclewizard.com
www.oraclewizard.com will be online soon.

<akkha_at_my-deja.com> wrote in message news:8aueud$9m4$1_at_nnrp1.deja.com...


> Hi,

>

> Is it possible to get the name of a stored package

>within the package itself?

>

> Thanks

>

> Anthony

>

>

> Sent via Deja.com http://www.deja.com/

> Before you buy.