I'm revisiting the use of Pipeline Pilot from Oracle stored procedures, and have been able to execute protocols from Oracle stored procedures (10g) using UTL_HTTP:

DEFINE
szREQ Utl_Http.req;
szRESP Utl_Http.resp;
szVALUE VARCHAR2(1024);

BEGIN
utl_http.set_transfer_timeout(2400);
szREQ := Utl_Http.begin_request ('http://scipilot:9944/perlbin/runjob.pl?_protocol=Protocols/SomeDirectory/SomeProtocol&_user=someuser&_password=somepw', 'GET');
szRESP := utl_http.get_response(szREQ);
LOOP
utl_http.read_line(szRESP, szVALUE, TRUE);
END LOOP;
utl_http.end_response(szRESP);
END;

This can run a protocol, but does not return values as a web service would. I think it would be possible to use UTL_DBWS to call a web service from Oracle, but I need to know the webservice namespace, service name, port name and operation name:

http://download-east.oracle.co.../u_dbws.htm#i1001372

While I can get the WSDL URL from the pipeline pilot web service inspector, I don't see where to obtain the other variables required by UTL_DBWS.

UTL_HTTP requires a Method name if you're using the code suggested in

http://akdora.wordpress.com/20...e-by-plsql-utl_http/

He has made available a SOAP access package, but I haven't been able to make this work without a Method name, and there will likely be other issues.

Has anyone tried either UTL_DBWS or UTL_HTTP?

Regards,
Chris Silvia