FETCH A PROCEDURE DEFINITION

HOW TO FETCH A PROCEDURE DEFINITION

SELECT TEXT FROM USER_SOURCE WHERE TYPE = 'PROCEDURE' AND NAME = PROCEDURE_NAME;

-- EXAMPLE
SELECT DBMS_METADATA.GET_DDL('TABLE','EMP_TABLE') FROM DUAL;
SELECT DBMS_METADATA.GET_DDL('PROCEDURE','EMP_DETAILS_PROC') FROM DUAL;

SELECT TEXT 
FROM USER_SOURCE 
 WHERE NAME IN ('application_func_name_here') 
 ORDER BY LINE; -- order is very important