SQL & PL/SQL

Dear All,

i want to extract the metadata for procedures and functions in my db.

i am using the DBMS_METADATA.GET_DDL(ObjectType,ObjectName) to get the metadata of certain objects (PROCEDURES,FUNCTIONS and PACKAGE_BODY)

however this method is not quiet usefull when my target is to get the metadata for a single procedure/function defined inside package's body', where i dont need

the whole package body to be returned only the specific Procedure/ Function defined in it...

it seems that the Package Body is defined as one object regardless of how many Procedures / Functions are defined in it...

isnt there any place/repository that stores the procedures and functions defined inside a package body along with their metadata explicitly one bye one , so i can

extract them and search them one bye one...

Thank you

Basem Sayej...