Re: Query for functions and procedures in Package

From: Jurij Modic <jurij.modic_at_mf.sigov.mail.si>
Date: 1997/06/18
Message-ID: <33a84e1f.20120349@www.sigov.si>#1/1

On Wed, 18 Jun 1997 12:39:29 +0700, Konstantin V Sartakov <skv_at_kpbank.ru> wrote:

>hi Stephen
>Stephen Lappin wrote:
>>
>> Is there dictionary view available that can be queried to show what
>> procedures and functions are contained within a Pl/SQL Package?
>
>
> Look at ALL_DEPENDENCIES, DBA_DEPENDENCIES & USER_DEPENDENCIES
>views.

You won't find what procedures/functions are contained in a package in those views. Those views give informations about what objects package is dependent on.

I am not aware of any view/table that explicitely lists all procedures or functions that exists in packages or package bodies.

Regards,

---

Jurij Modic                             Republic of Slovenia
tel: +386 61 178 55 14                  Ministry of Finance
fax: +386 61  21 45 84                  Zupanciceva 3

e-mail: jurij.modic_at_mf.sigov.mail.si Ljubljana 1000

---

Received on Wed Jun 18 1997 - 00:00:00 CDT