SQL*Plus – Run Script Behind Proxy on Windows

scriptingsqlpluswindows

In SQL*Plus, I try to run a script that is stored at a certain URL.

From where I am currently, I can http(s) connect with the internet only via a proxy.

So, if in SQL*Plus, I try

@https://here.is.url/script.sql

SQL*Plus won't find the script (as SQL*Plus doesn't seem to know about the proxy).

Is there a way to indicate what proxy to use and how to authenticate with that proxy?

Best Answer

Set the environment variable HTTP_PROXY.

HTTP_PROXY=http://username:password@proxyhost