Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
Hi All,
I need to find out all the functions written in a package (private and non-Private)
and corresponding RETURN type of the function .
SELECT * FROM ALL_PROCEDURES WHERE object_type='PACKAGE' AND owner =<>
AND object_name LIKE '<PKG_NAME>%'
AND procedure_name LIKE '<Function_name>%'
Gives me all the function names but not the private function of the pkg .(i.e. function not declared in pkg specification)
also from where I determine the return type of the function.
all of the function in the package start with F_ and all the private function start with FP_
in all of the packages.
Thank you.