I have a 10.2.0.3 database. I have a lot of packages under one schema. Each package contains few procedures and functions.
I need to identify which one is a function and which one is a procedure within a package. I can user dba_procedures to get the column of procedure_name.
However, the procedure_name column contains both function and procedure names.
Thanks a lot for any help on this.