Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Query for functions and procedures in Package
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.
Regards
Konstantin V. Sartakov Kuzbassprombank Kemerovo Russia mailto:skv_at_kpbank.ruReceived on Wed Jun 18 1997 - 00:00:00 CDT