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
UTL_DBWS (latest version from Metalink installed successfully (as per notes <i>IDs 469588.1, 841183.1</i>)

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:
The authentication proxy string format (as supported via Oracle's UTL_HTTP, operating systems and software like yum, wget, etc) is as follows:

However, this does not seem to work.
ORA-29532: Java call terminated by uncaught Java exception: HTTP transport
error: javax.xml.soap.SOAPException:
javax.xml.soap.SOAPException: Message send failed:
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?


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