Devart Forums

Posted: **Wed 22 Jul 2009 16:25**

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

Posted: **Wed 22 Jul 2009 16:48**

Try the following select:

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

Posted: **Thu 23 Jul 2009 14:56**

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?

Posted: **Mon 03 Aug 2009 09:20**

ODAC does not have such parser.