title: ORACLE - Exporting Procedures / Packages to a file
body: <p>I would like to programmatically  export my Procedures / Functions and Packages into individual files (as a backup) and using Oracle 9.2.</p>
  
  <p>The closest solution i found was using DBMS_METADATA.GET_DDL , but how do i output the CLOB to a text file, without losing any parts (due to length or indentation) ?</p>
  
  <p>Or maybe do you have other  solutions to backup packages or other functions individually (only the one i want, not all of them) ?</p>
  
  <p>Thanks</p>