Re: List Procedures in Packages

From: Dave Fowler <d.fowler_at_smmj.com>
Date: Thu, 17 May 2001 18:03:22 GMT
Message-ID: <KnUM6.12728$gc1.1138503@newsread1.prod.itd.earthlink.net>

Olaf,
You can use the all_arguments view select distinct package_name,object_name where owner='your_schema'

This has the argments to procedure/functions with datatypes. If your only concerned about packages where package_name is not null.

hth
Dave Fowler

"Olaf Lewitz" <Olaf.Lewitz_at_softwerft.de> wrote in message news:1m08gts1rc25lr4trp26k6noo0smavfvo9_at_4ax.com...
> Hi all,
>
> is there a more convenient way to list all the function and procedure
> names in a package than parsing the body and extracting the names from
> the source code?
>
> Thanks for any insight.
>
> Cheers,
> Olaf Lewitz
> ohltec SOFTWERFT GmbH
Received on Thu May 17 2001 - 13:03:22 CDT