This discussion is archived
2 Replies Latest reply: Feb 22, 2013 7:31 AM by 949766 RSS

Proxy Authentication for UTL_DWBS

BillyVerreynne Oracle ACE
Currently Being Moderated
Not sure where to ask this question - it is not a PL/SQL question as the code doing the request, is Java (jpub classes) running inside the database. And this seemed to me the most appropriate forum that deals with such a problem?

Db version:
Oracle RAC 11.2.0.2
UTL_DBWS (latest version from Metalink installed successfully (as per notes <i>IDs 469588.1, 841183.1</i>)

Problem:
Setting proxy authentication via UTL_DBWS.set_proxy() (wrapper for oracle.jpub.runtime.dbws.DbwsProxy.setHttpProxy).

 
Examples show on Metalink/support and else where on the net, shows this format only - non-authenticated proxy access:
utl_dbws.set_http_proxy('myproxyserver:8080'); 
The authentication proxy string format (as supported via Oracle's UTL_HTTP, operating systems and software like yum, wget, etc) is as follows:
<proxy-username>:<proxy-password>@<proxy-server>:<port>

e.g.
utl_dbws.set_http_proxy('scott:tiger@myproxyserver:8080'); 
However, this does not seem to work.
ORA-29532: Java call terminated by uncaught Java exception: HTTP transport
error: javax.xml.soap.SOAPException: java.security.PrivilegedActionException:
javax.xml.soap.SOAPException: Message send failed:
scott:tiger@myproxyserver:
scott:tiger@myproxyserver
ORA-06512: at "xxx.UTL_DBWS", line 404
The initial UTL_DBWS calls are successful (as per Oracle provided sample code). E.g. calls from utl_dbws.set_http_proxy and utl_dbws.create_service, to utl_dbws.set_property work - no exceptions thrown.

The above exception is thrown on the utl_dbws.invoke call - when the actual HTTP POST is made and the proxy needs to be used.

Line 404 (as per error stack) in UTL_DBWS is:
function invoke_proxy (request SYS.XMLTYPE) return SYS.XMLTYPE
as language java
    name 'oracle.jpub.runtime.dbws.DbwsProxy.invokeProxy(oracle.xdb.XMLType) return oracle.xdb.XMLType';
Is the JVM missing specific security? (this has been configured as per support notes).

Is the proxy string format (with authentication included), valid for oracle.jpub classes?

Some other issue?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points