Skip to Main Content
Forums

SQLcl: MCP Server & SQL Prompt

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!

Error while running script in Sqlcl

Orcl ApexOct 18 2017 — edited Oct 19 2017

Hi All,

Please suggest why I am getting this error in Sqlcl.

pastedImage_0.png
This post has been answered by Gary Graham-Oracle on Oct 19 2017
Jump to Answer

Comments

John Thorton

post COPY & PASTE proof that you can successfully run any "sample.sql"  script

post content of xplan.sql file

You can COPY directly from Windows CMD terminal.

Orcl Apex

I am not able to run even select * from dual script.

Paulzip

Probably should be moved to the SQLcl forums.

Gaz in Oz

sqlcl version?

BluShadow

*** Moderator Note: Question now moved to the SQLcl product space as this is more about the tool than the SQL or PL/SQL languages.

Gary Graham-Oracle
Answer

There is a bug in 17.3 with a workaround:  set encoding UTF8

For example...

SQL> show version
Oracle SQLDeveloper Command-Line (SQLcl) version: 17.3.0.256.1818
SQL> show encoding
Encoding:WE8MSWIN1252
SQL> @ test.sql  
Oct 19, 2017 11:18:56 AM oracle.dbtools.raptor.newscriptrunner.ScriptExecutor <init>
SEVERE: Could not process url:file:/C:/Tools/sqlcl/r17_3/sqlcl/bin/test.sql
Oct 19, 2017 11:18:56 AM oracle.dbtools.raptor.newscriptrunner.ScriptExecutor run
SEVERE: java.io.Reader.<init>(Unknown Source)
java.lang.NullPointerException
        at java.io.Reader.<init>(Unknown Source)
        at java.io.BufferedReader.<init>(Unknown Source)
        at java.io.BufferedReader.<init>(Unknown Source)
        at oracle.dbtools.raptor.newscriptrunner.ScriptParser.scriptParserInit(ScriptParser.java:87)
        at oracle.dbtools.raptor.newscriptrunner.ScriptParser.<init>(ScriptParser.java:83)
        at oracle.dbtools.raptor.newscriptrunner.ScriptParser.<init>(ScriptParser.java:75)
        at oracle.dbtools.raptor.newscriptrunner.FallbackParserProvider.<init>(FallbackParserProvider.java:22)
        at oracle.dbtools.raptor.newscriptrunner.SqlParserProvider.getScriptParserIterator(SqlParserProvider.java:25)
        at oracle.dbtools.raptor.newscriptrunner.ScriptExecutor.run(ScriptExecutor.java:169)
        at oracle.dbtools.raptor.newscriptrunner.SQLPLUS.runExecuteFile(SQLPLUS.java:3870)
        at oracle.dbtools.raptor.newscriptrunner.SQLPLUS.run(SQLPLUS.java:210)
        at oracle.dbtools.raptor.newscriptrunner.ScriptRunner.runSQLPLUS(ScriptRunner.java:406)
        at oracle.dbtools.raptor.newscriptrunner.ScriptRunner.run(ScriptRunner.java:243)
        at oracle.dbtools.raptor.newscriptrunner.ScriptExecutor.run(ScriptExecutor.java:337)
        at oracle.dbtools.raptor.newscriptrunner.ScriptExecutor.run(ScriptExecutor.java:225)
        at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.process(SqlCli.java:390)
        at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.processLine(SqlCli.java:401)
        at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.startSQLPlus(SqlCli.java:1225)
        at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.main(SqlCli.java:477)
SQL> set encoding UTF8
SQL> @ test.sql
D
-
X
SQL>

where test.sql contains "select * from dual;"

Marked as Answer by Orcl Apex · Oct 19 2017
BG4GRAPH

Hi,
this bug seems to have been reintroduced in SqlCl 21.3.
Notice that the workaround is not acceptable if the script does not have UTF8 encoding.

Yours,
BG4GRAPH.

1 - 7

Post Details

Added on Oct 18 2017
7 comments
2,604 views