I am running Oracle XE 18.104.22.168.0 on CentOS and having problem with https when calling through UTL_HTTP package when the SSL certificates of the server I access are signed with SSH-2. Oracle 22.214.171.124.0 and earlier can only handle SSH-1.
As there's no patch for XE this cannot be fixed.
UTL_HTTP however can take an argument for a Proxy server through which the required host can be accessed.
I am thinking to have some kind of proxy server to which Oracle UTL_HTTP can make http call and the proxy server in the background makes https call to the actual host.
But not sure how to do it and what do I need for this.
Any ideas are welcome.