My Oracle Support Banner

SQLcl Reports An Erroneous Error When Running a Script With Http_Proxy Environment Variable Set (Doc ID 2426633.1)

Last updated on OCTOBER 24, 2020

Applies to:

Oracle SQL Developer - Version 18.1 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
SQLcl 18.1 and Later
Database 12.2.0.1

Symptoms

SQLcl reports an erroneous error when running a script and http_proxy env variable is set.

For Example:

If the http_proxy environment variable is set, sqlcl 18.1.1 reports the following error when running a script:

SQL> @test.sql

Error
java.lang.NumberFormatException: For input string: "3128/"
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
at java.lang.Integer.parseInt(Integer.java:580)
at java.lang.Integer.parseInt(Integer.java:615)
at oracle.dbtools.common.utils.FileUtils.haveIBytes(FileUtils.java:215)
at oracle.dbtools.raptor.newscriptrunner.SQLPLUS.setExecutorPath(SQLPLUS.java:4014)
at oracle.dbtools.raptor.newscriptrunner.SQLPLUS.runExecuteFile(SQLPLUS.java:3890)
at oracle.dbtools.raptor.newscriptrunner.SQLPLUS.run(SQLPLUS.java:210)
at oracle.dbtools.raptor.newscriptrunner.ScriptRunner.runSQLPLUS(ScriptRunner.java:423)
at oracle.dbtools.raptor.newscriptrunner.ScriptRunner.run(ScriptRunner.java:260)
at oracle.dbtools.raptor.newscriptrunner.ScriptExecutor.run(ScriptExecutor.java:342)
at oracle.dbtools.raptor.newscriptrunner.ScriptExecutor.run(ScriptExecutor.java:225)
at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.process(SqlCli.java:398)
at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.processLine(SqlCli.java:409)
at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.startSQLPlus(SqlCli.java:1235)


However, it still returns results.

Works If:

Does Not Work If:

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
Symptoms
Changes
Cause
Solution
References


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