2 Replies Latest reply on May 4, 2015 11:24 AM by berx

    sqlcl 4.1.0.15.106.1020 trimspool kills sqlformat csv

    berx

      with these simple commands

       

      set trimspool on
      
      set sqlformat csv
      
      spool dual.csv
      
      select * from dual;
      
      spool off;
      
      

      I get that stack trace:

       

       

       

      Apr 23, 2015 12:54:46 PM oracle.dbtools.raptor.newscriptrunner.ScriptExecutor run
      SEVERE: java.lang.System.arraycopy(Native Method)
      java.lang.ArrayIndexOutOfBoundsException
              at java.lang.System.arraycopy(Native Method)
              at oracle.dbtools.raptor.newscriptrunner.WrapListenBufferOutputStream.write(WrapListenBufferOutputStream.java:183)
              at oracle.dbtools.raptor.newscriptrunner.WrapListenBufferOutputStream.reallywrite(WrapListenBufferOutputStream.java:227)
              at oracle.dbtools.raptor.newscriptrunner.WrapListenBufferOutputStream.write(WrapListenBufferOutputStream.java:217)
              at sun.nio.cs.StreamEncoder.writeBytes(StreamEncoder.java:221)
              at sun.nio.cs.StreamEncoder.implFlushBuffer(StreamEncoder.java:291)
              at sun.nio.cs.StreamEncoder.implFlush(StreamEncoder.java:295)
              at sun.nio.cs.StreamEncoder.flush(StreamEncoder.java:141)
              at java.io.OutputStreamWriter.flush(OutputStreamWriter.java:229)
              at oracle.dbtools.raptor.format.ResultsFormatter.print(ResultsFormatter.java:566)
              at oracle.dbtools.db.ResultSetFormatter.formatResults(ResultSetFormatter.java:105)
              at oracle.dbtools.db.ResultSetFormatter.formatResults(ResultSetFormatter.java:61)
              at oracle.dbtools.raptor.newscriptrunner.SQL.processResultSet(SQL.java:494)
              at oracle.dbtools.raptor.newscriptrunner.SQL.executeQuery(SQL.java:418)
              at oracle.dbtools.raptor.newscriptrunner.SQL.run(SQL.java:56)
              at oracle.dbtools.raptor.newscriptrunner.ScriptRunner.runSQL(ScriptRunner.java:294)
              at oracle.dbtools.raptor.newscriptrunner.ScriptRunner.run(ScriptRunner.java:202)
              at oracle.dbtools.raptor.newscriptrunner.ScriptExecutor.run(ScriptExecutor.java:269)
              at oracle.dbtools.raptor.newscriptrunner.ScriptExecutor.run(ScriptExecutor.java:180)
              at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.process(SqlCli.java:250)
              at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.processLine(SqlCli.java:257)
              at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.startSQLPlus(SqlCli.java:682)
              at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.main(SqlCli.java:297)
      
      

      can anyone please reproduce?