2 Replies Latest reply: Feb 22, 2013 9:31 AM by 949766 RSS

    Proxy Authentication for UTL_DWBS

      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: java.security.PrivilegedActionException:
      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?