Is there a way to list functions/procedures in a package?

[dados]

Is there a way to list functions/procedures in a package? or any pl/sql parser

[jfudickar]

Try the following select:

Code: Select all

select  DECODE (MIN(POSITION),
                1, 'PROCEDURE',
                0, 'FUNCTION', NULL) TYPE,
                object_name
  from  all_arguments
  where owner = :owner
    and package_name = :package_name
  group by package_name, object_name

This will work only with the public procedures. Not the internal procedures.

Kind regards
Jens

[dados]

Thanks, but I'm really looking for a plsql parser that I can use to list all ext/int func/proc/varibles in a package/func/proc...any ideas?

[Plash]

ODAC does not have such parser.