Skip to Main Content

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