Re: How to retrieve function metadata?

For object level information (aggregate, deterministic, authid type etc.) look in the ALL_PROCEDURES and USER_PROCEDURES views. For example, an aggregate function is indicated by 'YES' in 'AGGREGATE' column, with the aggregated object type given by 'IMPLTYPEOWNER' and 'IMPLTYPENAME' columns and the parallel option in the 'PARALLEL' column.

For formal parameter level information (including return type) check in the ALL_ARGUMENTS or USER_ARGUMENTS views.

--
Posted via http://dbforums.com