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 AUGUST 04, 2018

Applies to:

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


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

java.lang.NumberFormatException: For input string: "3128/"
at java.lang.NumberFormatException.forInputString(
at java.lang.Integer.parseInt(
at java.lang.Integer.parseInt(
at oracle.dbtools.common.utils.FileUtils.haveIBytes(
at oracle.dbtools.raptor.newscriptrunner.SQLPLUS.setExecutorPath(
at oracle.dbtools.raptor.newscriptrunner.SQLPLUS.runExecuteFile(
at oracle.dbtools.raptor.newscriptrunner.ScriptRunner.runSQLPLUS(
at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.process(
at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.processLine(
at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.startSQLPlus(

However, it still returns results.

Works If:

Does Not Work If:


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

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

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