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 = 'XXTAMS_UNIGROUP_SEND_EMAIL_PKG'  -- package name

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

 ORDER BY ds.line;