Re: List Procedures in Packages

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Thu, 17 May 2001 18:46:11 -0400
Message-ID: <11l8gtogsap7aqo1vp6c0uo3r9sm6mhkf8@4ax.com>

A copy of this was sent to Olaf Lewitz <Olaf.Lewitz_at_softwerft.de> (if that email address didn't require changing) On Thu, 17 May 2001 18:58:49 +0200, you wrote:

>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?
>

the views ALL_ARGUMENTS and USER_ARGUMENTS make this ease.

tkyte_at_TKYTE816> select distinct object_name from all_arguments where   2 package_name = 'DBMS_OUTPUT' and owner = 'SYS';

OBJECT_NAME

---

DISABLE
ENABLE

GET_LINE
GET_LINES
NEW_LINE

PUT
PUT_LINE 7 rows selected.

>Thanks for any insight.
>
>Cheers,
>Olaf Lewitz
>ohltec SOFTWERFT GmbH

--
Thomas Kyte (tkyte_at_us.oracle.com) Oracle Service Industries
Howtos and such: http://asktom.oracle.com/
Oracle Magazine: http://www.oracle.com/oramag
Opinions are mine and do not necessarily reflect those of Oracle Corp 

Received on Thu May 17 2001 - 17:46:11 CDT