Calling a BPEL process with UTL_DBWS PLSQL package

After struggeling with low level SOAP calls from PLSQL. I was able to use the UTL_DBWS package. This package gives you an abstract layer on top of the low-level SOAP calls. On OTN the latest version of this package can be downloaded. You have to execute the following steps: Download the CallOut WebService zip file. Execute note: 276554.1 (located at metalink.oracle.com) Load under 'sys' account the files dbwsa.jar then dbwsclient.jar (from the previous donwloaded zip files) loadjava -u sys/change_on_install -r -v -f -genmissing –s –grant public dbwsa.jar loadjava -u sys/change_on_install -r -v -f -genmissing –s –grant public dbwsclient.jar After this step, apart of errors during the loading of the jar files, you must load the two sqlfiles; utl_dbws_body.sql, utl_dbws_decl.sql as owner sys. Now you should able to call a web service from the database, here is an example of calling a BPEL process based on a document style (rpc is also working). DECLARE service_ utl_dbws.SERVICE; call_ utl_dbws.CALL; service_qname utl_dbws.QNAME; port_qname utl_dbws.QNAME; xoperation_qname utl_dbws.QNAME; xstring_type_qname utl_dbws.QNAME; response sys.XMLTYPE; request sys.XMLTYPE; begin -- Set a proxy if needed -- utl_dbws.set_http_proxy('www-proxy.oracle.com:80'); service_qname := utl_dbws.to_qname(null, 'HelloWorld'); service_ := utl_dbws.create_service(service_qname); -- call_ := utl_dbws.create_call(service_); -- utl_dbws.set_target_endpoint_address(call_, 'http://oracle.nl:7779/orabpel/default/HelloWorld/1.0'); utl_dbws.set_property(call_,'SOAPACTION_USE','TRUE'); utl_dbws.set_property(call_,'SOAPACTION_URI','process'); utl_dbws.set_property(call_,'OPERATION_STYLE','document'); -- -- Set the input -- request := sys.XMLTYPE(' <HelloWorldProcessRequest xmlns="http://oracle.nl/HelloWorld"> <input xmlns="http://oracle.nl/HelloWorld"> 1234abcd </input> </helloworldprocessrequest>'); -- response := utl_dbws.invoke(call_, request); -- dbms_output.put_line(response.getstringval()); end; /