0 Replies Latest reply on Mar 10, 2015 9:32 AM by andriy

    Some issues of sqlcl EA2 running with login.sql

    andriy

      Hi!

       

      I have an error running sqlcl with my default login.sql (which I've stolen from Tanel Poder scripts library). I believe the error is due to that login.sql, because after set SQLPATH='' it work good. This error comes with new EA2 release.

       

      C:\Users\admitr>Apps\sqlcl\bin\sql admitr@dev1

       

      SQLcl: Release 4.1.0 Beta on тЄ схЁ. 10 11:23:23 2015

       

      Copyright (c) 1982, 2015, Oracle.  All rights reserved.

       

       

      Password? (**********?) *************

      Connected to:

      Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

       

      line 90: "set tab off" is Obsolete.

       

      схЁ. 10, 2015 11:23:29 AM oracle.dbtools.raptor.newscriptrunner.ScriptExecutor run

      SEVERE: java.lang.AbstractStringBuilder.substring(Unknown Source)

      java.lang.StringIndexOutOfBoundsException: String index out of range: 175

              at java.lang.AbstractStringBuilder.substring(Unknown Source)

              at java.lang.StringBuffer.substring(Unknown Source)

              at oracle.dbtools.db.SQLPLUSCmdFormatter.adjustToLineandPageSize(SQLPLUSCmdFormatter.java:2344)

              at oracle.dbtools.db.SQLPLUSCmdFormatter.rset2sqlplus(SQLPLUSCmdFormatter.java:362)

              at oracle.dbtools.db.ResultSetFormatter.rset2sqlplus(ResultSetFormatter.java:241)

              at oracle.dbtools.db.ResultSetFormatter.rset2sqlplus(ResultSetFormatter.java:215)

              at oracle.dbtools.db.ResultSetFormatter.formatResults(ResultSetFormatter.java:120)

              at oracle.dbtools.db.ResultSetFormatter.formatResults(ResultSetFormatter.java:61)

              at oracle.dbtools.raptor.newscriptrunner.SQL.processResultSet(SQL.java:497)

              at oracle.dbtools.raptor.newscriptrunner.SQL.executeQuery(SQL.java:421)

              at oracle.dbtools.raptor.newscriptrunner.SQL.run(SQL.java:56)

              at oracle.dbtools.raptor.newscriptrunner.ScriptRunner.runSQL(ScriptRunner.java:280)

              at oracle.dbtools.raptor.newscriptrunner.ScriptRunner.run(ScriptRunner.java:200)

              at oracle.dbtools.raptor.newscriptrunner.ScriptExecutor.run(ScriptExecutor.java:267)

              at oracle.dbtools.raptor.newscriptrunner.ScriptExecutor.run(ScriptExecutor.java:180)

              at oracle.dbtools.raptor.newscriptrunner.SQLPLUS.runExecuteFile(SQLPLUS.java:2802)

              at oracle.dbtools.raptor.newscriptrunner.SQLPLUS.run(SQLPLUS.java:139)

              at oracle.dbtools.raptor.newscriptrunner.ScriptRunner.runSQLPLUS(ScriptRunner.java:296)

              at oracle.dbtools.raptor.newscriptrunner.ScriptRunner.run(ScriptRunner.java:214)

              at oracle.dbtools.raptor.newscriptrunner.ScriptExecutor.run(ScriptExecutor.java:267)

              at oracle.dbtools.raptor.newscriptrunner.ScriptExecutor.run(ScriptExecutor.java:180)

              at oracle.dbtools.raptor.newscriptrunner.SQLPLUS.runLoginSQL(SQLPLUS.java:2037)

              at oracle.dbtools.raptor.newscriptrunner.SQLPLUS.runConnect(SQLPLUS.java:1806)

              at oracle.dbtools.raptor.newscriptrunner.SQLPLUS.run(SQLPLUS.java:146)

              at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.handleLoginSql(SqlCli.java:569)

              at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.main(SqlCli.java:317)

       

      ADMITR@NA/NA >

       

      Also it doesn't understand the command

       

      host title &i_user@&_i_conn [sid=&mysid ser#=&_i_serial spid=&_i_spid inst=&_i_inst host=&_i_host cpid=&_i_cpid opid=&_i_opid]

       

      from i.sql line 60. The errors are:

       

      'i_user@' is not recognized as an internal or external command,

      operable program or batch file.

      '_i_conn' is not recognized as an internal or external command,

      operable program or batch file.

      'mysid' is not recognized as an internal or external command,

      operable program or batch file.

      '_i_serial' is not recognized as an internal or external command,

      operable program or batch file.

      '_i_spid' is not recognized as an internal or external command,

      operable program or batch file.

      '_i_inst' is not recognized as an internal or external command,

      operable program or batch file.

      '_i_host' is not recognized as an internal or external command,

      operable program or batch file.

      '_i_cpid' is not recognized as an internal or external command,

      operable program or batch file.

      '_i_opid]' is not recognized as an internal or external command,

      operable program or batch file.

       

      As I understood the command processing is not compatible with sqlplus's one.

       

      Thanks.

      Andriy.