Query to read stored procedure off the database

Query to read stored procedure off the database.

-------------------------------------------------------------------------------

-- Query to read stored procedure off the database

-------------------------------------------------------------------------------

SELECT ds.text

  FROM dba_source ds

 WHERE ds.NAME = 'XX_SEND_EMAIL_PKG'  -- package name

   AND ds.TYPE = 'PACKAGE BODY'       -- package type

 ORDER BY ds.line;