execute.sql.erb 282 B

1234567891011121314151617
  1. connect / as sysdba
  2. SET PAGES 0 EMB ON NEWP NONE
  3. SET NEWPAGE 0
  4. SET SPACE 0
  5. SET LINESIZE 32767
  6. SET ECHO OFF
  7. SET FEEDBACK OFF
  8. SET VERIFY OFF
  9. WHENEVER SQLERROR EXIT 2
  10. SET HEADING ON
  11. SET MARKUP HTML OFF SPOOL OFF
  12. SET COLSEP ','
  13. SPOOL <%= outFile.path %>
  14. <%= command %>
  15. /
  16. spool off
  17. exit