SQLcl 19.1 & 19.2 Shows Incorrect Output/Error When SQLFORMAT Is DEFAULT (Doc ID 2579430.1)

Last updated on MARCH 09, 2023

Applies to:

Oracle SQL Developer - Version 19.1 to 19.3
Oracle SQLcl - Version 19.1 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR

SQLcl 19.1 & 19.2 gives error while executing below SQL query when SQLFORMAT is DEFAULT.

SQL> SELECT * FROM dba_scheduler_job_run_details WHERE status = 'FAILED' ORDER BY log_date DESC;

Aug 21, 2019 6:24:43 PM oracle.dbtools.raptor.newscriptrunner.ScriptExecutor run
SEVERE: oracle.dbtools.raptor.newscriptrunner.ScriptUtils.bytesToHex(ScriptUtils.java:830)
java.lang.NullPointerException
        at oracle.dbtools.raptor.newscriptrunner.ScriptUtils.bytesToHex(ScriptUtils.java:830)
        at oracle.dbtools.db.SQLPLUSCmdFormatter.rset2sqlplus(SQLPLUSCmdFormatter.java:1178)
        at oracle.dbtools.db.ResultSetFormatter.rset2sqlplus(ResultSetFormatter.java:334)
        at oracle.dbtools.db.ResultSetFormatter.rset2sqlplus(ResultSetFormatter.java:308)
        at oracle.dbtools.db.ResultSetFormatter.formatResults(ResultSetFormatter.java:153)
        at oracle.dbtools.db.ResultSetFormatter.formatResults(ResultSetFormatter.java:71)
        at oracle.dbtools.raptor.newscriptrunner.SQL.processResultSet(SQL.java:798)
        at oracle.dbtools.raptor.newscriptrunner.SQL.executeQuery(SQL.java:709)
        at oracle.dbtools.raptor.newscriptrunner.SQL.run(SQL.java:83)
        at oracle.dbtools.raptor.newscriptrunner.ScriptRunner.runSQL(ScriptRunner.java:405)
        at oracle.dbtools.raptor.newscriptrunner.ScriptRunner.run(ScriptRunner.java:231)
        at oracle.dbtools.raptor.newscriptrunner.ScriptExecutor.run(ScriptExecutor.java:344)
        at oracle.dbtools.raptor.newscriptrunner.ScriptExecutor.run(ScriptExecutor.java:227)
        at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.process(SqlCli.java:405)
        at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.processLine(SqlCli.java:416)
        at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.startSQLPlus(SqlCli.java:1250)
        at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.main(SqlCli.java:492)

EXPECTED BEHAVIOR

SQLcl should return correct number of rows like SQL*Plus and SQL Developer.

Note: It works fine in latest versions of SQL Developer 19.2.1.x. It also works fine and returns correct results in SQL*Plus 12.1.0.2.0 and 12.2.0.1.0 versions.

Changes

Cause

	To view full details, sign in with your My Oracle Support account.
	Don't have a My Oracle Support account? Click to get started!

In this Document

SQL Developer Command Line 19.3 Downloads

References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.

SQLcl 19.1 & 19.2 Shows Incorrect Output/Error When SQLFORMAT Is DEFAULT (Doc ID 2579430.1)

Applies to:

Symptoms

Changes

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!