Packages

[jeyaseelan]

Does anybody can tell me to find out the procedures available in a packages.

Ex: I know the package name like DBMS_SQL.

I would like to know the procedures which is available under the packages


Thankx
M.Jeyaseelan

[akkerend]

In SQL*PLus Release 8 you can use DESC:
DESC your_package

Or you can use ALL_SOURCE view:
SELECT text
FROM all_source
WHERE type = 'PACKAGE'
AND name = 'YOUR_PACKAGE'
ORDER BY line;