Unanswered: OracleXMLSave using URL with authentication
We have an Oracle 9i DB that needs to pull xml from a web site and insert it. This will be done from a Java Stored Proc that sets-up the environment then calls the OracleXMLSave.insertXML(java.net.URL url) method.
This works fine if the web page it's pulling from is not protected, but because of the project's requirements it is protected with http basic security. We've been able to view pages using the UTL_HTTP package in PL/SQL successfully so we know it's possible to get in.
How can I code the username/pass into the java.net.URL argument? Is it possible? Or do I have to use one of the other insertXML methods?