SQLcl

SQLcl - alias causes ScriptParser error, or user error?

Craig ElliottFeb 25 2016 — edited Apr 22 2016

I discovered the latest version of SQLcl , so remove the older and unzipped the new. Now when I try to run my alias commands they fail.

Anyone have an ideas? Maybe I need to reinstall instantclient 11.2?

SQLcl 4.2.0.16.049.0842 RC on OSX 10.11.3

sho jdbc

-- Database Info --

Database Product Name: Oracle

Database Product Version: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, Oracle Label Security, OLAP, Data Mining

and Real Application Testing options

Database Major Version: 11

Database Minor Version: 2

-- Driver Info --

Driver Name: Oracle JDBC driver

Driver Version: 12.1.0.2.0

Driver Major Version: 12

Driver Minor Version: 1

Driver URL: jdbc:oracle:thin:

12:43:32 25-FEB-16 SYSTEM@test SQL >alias list

fred

locks - locks <USERNAME>

mysql

objects

plan

plan2

sessions

tables - tables <schema> - show tables from schema

tables2 - tables <schema> - show tables from schema

tablespace

temp

whoexec

SQL >alias list fred

fred

----

select :one from dual

SQL >fred sysdate

Feb 25, 2016 12:43:54 PM oracle.dbtools.raptor.newscriptrunner.ScriptExecutor run

SEVERE: oracle.dbtools.raptor.newscriptrunner.ScriptParser.findEndOfSQLAndPLSQL(ScriptParser.java:952)

java.lang.NullPointerException

at oracle.dbtools.raptor.newscriptrunner.ScriptParser.findEndOfSQLAndPLSQL(ScriptParser.java:952)

at oracle.dbtools.raptor.newscriptrunner.ScriptParser.identifyEndOfStatement(ScriptParser.java:1092)

at oracle.dbtools.raptor.newscriptrunner.ScriptParser.next(ScriptParser.java:251)

at oracle.dbtools.raptor.newscriptrunner.SQLPLUS.runAliases(SQLPLUS.java:3784)

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

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

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

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

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

at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.process(SqlCli.java:293)

at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.processLine(SqlCli.java:303)

at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.startSQLPlus(SqlCli.java:880)

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

SQL >sessions

Feb 25, 2016 12:48:42 PM oracle.dbtools.raptor.newscriptrunner.ScriptExecutor run