Re: Enumerate functions and procedures in PLSQL Package: How?
From: Odd Morten Sveås <odd.morten.sveas_at_accenture.com>
Date: 28 Sep 2002 14:50:33 -0700
Message-ID: <4306a83.0209281350.11f2c6d4_at_posting.google.com>
Date: 28 Sep 2002 14:50:33 -0700
Message-ID: <4306a83.0209281350.11f2c6d4_at_posting.google.com>
"news.clara.net" <gerrit_at_clara.net> wrote in message news:<1033221626.21608.0_at_dyke.uk.clara.net>...
> IDE's like PLSQLDeveloper and ORA very quickly show you all the *compiled*
> functions and procdures in a package (e.g. can't use the ALL_SOURCE
> dictionary view).
> How is this done / which dictionary view should I use?
> Gerrit Hoekstra
Hi
sys.dba_object or v_$all_views have an status column witch will show values like 'VALID' or 'INVALID'. There also is an column, OBJECT_TYPE witch is 'PACKAGE', 'BACKAGE BODY' and so on.
Regards
Odd M
Received on Sat Sep 28 2002 - 23:50:33 CEST