Re: how to get function/procedure name and type in a package

you can check all_arguments

 if for a given object_name in a given package_name if there is an argument at position 0 then it is a function otherwise it is a procedure.

there is a neat decode that I submitted to OTN few months ago, but can't locate it.

Raj

--
http://www.freelists.org/webpage/oracle-l