set serveroutput on; set heading off; set linesize 256; set pagesize 0; set feedback off; spool c:\PACKAGE.txt; SELECT rtrim(text) FROM All_Source WHERE owner = 'Schema Name' AND name = 'Package Name' ORDER BY LINE; spool off; set feedback off;