Click to See Complete Forum and Search --> : view procedure names of packages


aburker
06-04-2003, 03:59 AM
is there a method to list all procedures/functions of certain packages.

i know about dba_source but want to find an easier way

thx

ales
06-04-2003, 04:06 AM
In SQL*Plus, type "desc package_name".

pando
06-04-2003, 07:45 AM
for package´s proc & functions

select distinct object_name
from all_arguments
where package_name='DBMS_STATS';

for package´s procs & fncion´s arguments

select object_name, argument_name
from all_arguments
where package_name='DBMS_STATS'