[b] Example of use of utl_dbws not working properly [/b]
create or replace
function prova return varchar2
is
  service_           sys.utl_dbws.SERVICE;
  call_              sys.utl_dbws.CALL;
  service_qname      sys.utl_dbws.QNAME;
  port_qname         sys.utl_dbws.QNAME;
  xoperation_qname   sys.utl_dbws.QNAME;
  xstring_type_qname sys.utl_dbws.QNAME;
--  response           anydata;
  response           sys.xmltype;
  richiesta            sys.xmltype;
  richiestastring           varchar2(2000);
--  request            varchar2(2000);
  wsdl_url		varchar2(2000);
  l_input_params	sys.utl_dbws.anydata_list;
  string_type_qname     sys.utl_dbws.QNAME;
begin
  wsdl_url:= 'http://www.comune.grosseto.it/jEnteTest/services/JProtocolloWebservice?wsdl';
  service_qname := sys.utl_dbws.to_qname(null, 'JProtocolloWebservice');
  port_qname := sys.utl_dbws.to_qname(null,'JProtocolloWebservice');
  xoperation_qname:=sys.utl_dbws.to_qname(null,'leggiProtocollo');
  service_ := sys.utl_dbws.create_service( wsdl_document_location => URIFACTORY.getURI(wsdl_url), service_name => service_qname);
  call_ := sys.utl_dbws.create_call( service_handle => service_, port_name => NULL, operation_name => xoperation_qname);
  richiesta := sys.xmltype('<?xml version="1.0" encoding="utf-8"?><LeggiProtocollo><Utente>JENTE</Utente><Protocollo><Registro>GE</Registro>'|| '<Sezione>GE</Sezione><Anno>2009</Anno><Numero>0200001</Numero>'||'</Protocollo></LeggiProtocollo>');
  richiestastring := '<?xml version="1.0" encoding="utf-8"?><LeggiProtocollo><Utente>JENTE</Utente><Protocollo><Registro>GE</Registro>'|| '<Sezione>GE</Sezione><Anno>2009</Anno><Numero>0200001</Numero>'||'</Protocollo></LeggiProtocollo>';
    sys.utl_dbws.set_property(call_,'OPERATION_STYLE','DOCUMENT');
--    sys.utl_dbws.set_property(call_,'OPERATION_STYLE','RPC');
  string_type_qname := sys.utl_dbws.to_qname('http://www.w3.org/2001/XMLSchema', 'string');
  sys.utl_dbws.add_parameter(call_, 'Request', string_type_qname, 'ParameterMode.IN');
--  l_input_params(0):=anydata.ConvertVarchar('PIPPO');
  sys.utl_dbws.set_return_type(call_,string_type_qname);
--  response:= utl_dbws.invoke(call_Handle=>call_, l_input_params);
  response:= utl_dbws.invoke(call_Handle=>call_, request=> richiesta);
  return 'OK';
end;
/

[b] Errors in execution of invoke [/b]

SQL> @prova

Function created.

SQL> select prova from dual;
select prova from dual
       *
ERROR at line 1:
ORA-00932: inconsistent datatypes: expected an IN argument at position 1 that
is an instance of an Oracle type convertible to an instance of a user defined
Java class got an exception while converting to the user class


[b] Example of pure java working [/b]
package it.test;

import it.arezzo.infor.*;
import it.arezzo.infor.jente.jprotocollo.webservice.service.JProtocolloWebservice;
import it.arezzo.infor.jente.jprotocollo.webservice.service.JProtocolloWebserviceServiceLocator;
import it.arezzo.infor.jente.webservices.jprotocollo.leggiprotocollo.esito.RispostaDocument;
import it.arezzo.infor.jente.webservices.jprotocollo.leggiprotocollo.esito.RispostaDocument.Risposta;

public class TestWS {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub

		//it.arezzo.infor.jente.jprotocollo.webservice.serviceClient wsc =
new it.arezzo.infor.jente.jprotocollo.webservice.serviceClient();
		
		try
		{
			String indirizzows =
"http://www.comune.grosseto.it/jEnteTest/services/JProtocolloWebservice";
			
			JProtocolloWebserviceServiceLocator services = new
JProtocolloWebserviceServiceLocator();
			services.setJProtocolloWebserviceEndpointAddress(indirizzows);
			
			JProtocolloWebservice protocolloService =
services.getJProtocolloWebservice();
			
			String xml = "<LeggiProtocollo>
<Utente>LVRTNN63E07H501T</Utente><Protocollo><Registro>GE</Registro><Sezione>GE</Sezione><Anno>2009</Anno><Anno>0200014</Anno></Protocollo></LeggiProtocollo>";
			
			String rispostaLeggi = protocolloService.leggiProtocollo(xml);
			
			RispostaDocument risposta = RispostaDocument.Factory.parse(rispostaLeggi);
			
			System.out.println("***RISPOSTA: "+rispostaLeggi+" ***");
			
			System.out.println(risposta.getRisposta().getEsito());
			System.out.println(risposta.getRisposta().getProtocollo().toString());
			
			
		} catch (Exception ex)
		{
			ex.printStackTrace();
		}
		
	}

}


[b]Wsdl definition [/b]
--
<wsdl:definitions targetNamespace="urn:JProtocolloWebservice">
−
<!--
WSDL created by Apache Axis version: 1.4
Built on Apr 22, 2006 (06:55:48 PDT)
-->
−
<wsdl:message name="leggiProtocolloRequest">
<wsdl:part name="in0" type="soapenc:string"/>
</wsdl:message>
−
<wsdl:message name="leggiProtocolloResponse">
<wsdl:part name="leggiProtocolloReturn" type="soapenc:string"/>
</wsdl:message>
−
<wsdl:message name="protocollaResponse">
<wsdl:part name="protocollaReturn" type="soapenc:string"/>
</wsdl:message>
−
<wsdl:message name="protocollaRequest">
<wsdl:part name="in0" type="soapenc:string"/>
</wsdl:message>
−
<wsdl:portType name="JProtocolloWebservice">
−
<wsdl:operation name="protocolla" parameterOrder="in0">
<wsdl:input message="impl:protocollaRequest" name="protocollaRequest"/>
<wsdl:output message="impl:protocollaResponse" name="protocollaResponse"/>
</wsdl:operation>
−
<wsdl:operation name="leggiProtocollo" parameterOrder="in0">
<wsdl:input message="impl:leggiProtocolloRequest" name="leggiProtocolloRequest"/>
<wsdl:output message="impl:leggiProtocolloResponse" name="leggiProtocolloResponse"/>
</wsdl:operation>
</wsdl:portType>
−
<wsdl:binding name="JProtocolloWebserviceSoapBinding" type="impl:JProtocolloWebservice">
<wsdlsoap:binding style="rpc" transport="http://schemas.xmlsoap.org/soap/http"/>
−
<wsdl:operation name="protocolla">
<wsdlsoap:operation soapAction=""/>
−
<wsdl:input name="protocollaRequest">
<wsdlsoap:body encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" namespace="urn:JProtocolloWebservice.webservices.infor.arezzo.it" use="encoded"/>
</wsdl:input>
−
<wsdl:output name="protocollaResponse">
<wsdlsoap:body encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" namespace="urn:JProtocolloWebservice" use="encoded"/>
</wsdl:output>
</wsdl:operation>
−
<wsdl:operation name="leggiProtocollo">
<wsdlsoap:operation soapAction=""/>
−
<wsdl:input name="leggiProtocolloRequest">
<wsdlsoap:body encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" namespace="urn:JProtocolloWebservice.webservices.infor.arezzo.it" use="encoded"/>
</wsdl:input>
−
<wsdl:output name="leggiProtocolloResponse">
<wsdlsoap:body encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" namespace="urn:JProtocolloWebservice" use="encoded"/>
</wsdl:output>
</wsdl:operation>
</wsdl:binding>
−
<wsdl:service name="JProtocolloWebserviceService">
−
<wsdl:port binding="impl:JProtocolloWebserviceSoapBinding" name="JProtocolloWebservice">
<wsdlsoap:address location="http://10.0.1.47:8080/jEnteTest/services/JProtocolloWebservice"/>
</wsdl:port>
</wsdl:service>
</wsdl:definitions>