title: copying stored procedures each into its own file using ant
body: <p>I want to be able to have an ant task which would connect to a remote oracle instance and copy the stored procedures each into its own file.  I know I can have an ant sql task which will do  </p>
  
  <pre><code>SELECT object_type, 
         object_name, 
         dbms_metadata.get_ddl(object_type, object_name) object_ddl 
  FROM user_objects
  WHERE OBJECT_TYPE in ('INDEX', 'TRIGGER', 'TABLE', 'VIEW', 'PACKAGE', 'FUNCTION', 'PROCEDURE', 'SYNONYM', 'TYPE')  
  ORDER BY OBJECT_TYPE, OBJECT_NAME
  </code></pre>
  
  <p>but this will get the result set all into one file, whereas I want a file per each procedure (this is because I intend to subsequently diff them against what's in SVN).</p>
  
  <p>Any ideas?</p>
  
  <p>Thanks!
  Alex</p>