How to get the list of available packaged procedures?

[fguionne]

How can you get the list of packaged stored procedures and functions ?
the table ALL_OBJECT only list standalone stored procedures and functions AND available packages.

how could you go one level beyond and get the function/procedures list from the package ?

Getting the package definition through ALL_SOURCE is not convenient for me.

I cannot believe this information is not stored somewhere else !?

Thanks for any tip

Frantz

 

[karluk]

The SQL*Plus "describe" command lists the individual components of a package.

 

[JFlack]

The built-in packages are well documented in the Oracle Supplied PL/SQL Packages Guide. This document is obtainable in PDF format from

http://technet.oracle.com.

If you don't want to do a SELECT from ALL_SOURCE, look in %ORACLE_HOME%/RDBMS/SQL at the various package specification files called by CATPROC.SQL. Oracle commented the heck out of these things. Don't bother with the ".plb" files, though, they aren't meant for human eyes.