2 Replies Latest reply on Jan 2, 2018 2:45 PM by Erik van Roon

    Errors in sql.bat 17.4.0.354.2224

    Erik van Roon

      For those running into the same problems I found:

       

      Problem:

      SQLcl 17.4.0.354.2224 which was released on December 22, 2017 has a couple of problems in the shipped sql.bat file for windows.

       

      Running it results in:

      • Message: "Environment variable echo on not defined"
      • Message: "The input line is too long"
      • SQLcl does'n start

      SQLcl_Batchfile_error.jpg

      Solution:

      comment-out 4 lines in the supplied [sqlcl]\bin\sql.bat

      (Add "rem " to the beginning of eachof these lines)

      • Line 37
        SET DEBUG=-agentlib:jdwp=transport=dt_socket,server=y,suspend=y,address=8000
      • Line 47
        set echo on

        This line causes the 'environment variable error'
        If you really want to set echo on, turn it into:
        @echo on
        But then, be prepared for lots of junk echoed to screen

      • Line 77 and Line 88
        Two comments, both starting with "<!-- " and ending with "-->"

        These redirection symbols (< and >) cause the "input line is too long"

       

      Result

      Edited_SQLcl_Batchfile.jpg