SQLcl

1 error has occurred

Your session has timed out.

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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