dbms_metadata.GET_DDL

dbms_metadata.GET_DDL('PROCEDURE',u.object_name)


select
dbms_metadata.GET_DDL('PROCEDURE',u.object_name)
from
user_objects u
where
object_type = 'PROCEDURE';