oracle webservice

Oracle stored procedure调用web service

 

create or replace FUNCTION TESTBCWEBSERVICE RETURN VARCHAR2 AS

 l_service  sys.UTL_DBWS.service;
 l_call     sys.UTL_DBWS.call;
 l_result   ANYDATA;

 l_wsdl_url         VARCHAR2(32767);
 l_namespace        VARCHAR2(32767);
 l_service_qname    sys.UTL_DBWS.qname;
 l_port_qname       sys.UTL_DBWS.qname;
 l_operation_qname  sys.UTL_DBWS.qname;
 l_input_params     sys.UTL_DBWS.anydata_list;
BEGIN
 l_wsdl_url        := 'http://192.168.88.126:8400/axis/BCWebService.jws?wsdl';
 l_namespace       := 'http://192.168.88.126:8400/axis/BCWebService.jws';

 l_service_qname   := sys.UTL_DBWS.to_qname(l_namespace, 'BCWebServiceService');
 l_port_qname      := sys.UTL_DBWS.to_qname(l_namespace, 'BCWebService');
 l_operation_qname := sys.UTL_DBWS.to_qname(l_namespace, 'validateXML');

 l_service := sys.UTL_DBWS.create_service (
   wsdl_document_location => URIFACTORY.getURI(l_wsdl_url),
   service_name           => l_service_qname);

 l_call := sys.UTL_DBWS.create_call (
   service_handle => l_service,
   port_name      => l_port_qname,
   operation_name => l_operation_qname);

 l_input_params(0) := ANYDATA.ConvertVarchar2('55555');
  l_input_params(1) := ANYDATA.ConvertVarchar2('11111111'); 
  
 l_result := sys.UTL_DBWS.invoke (
   call_handle  => l_call,
   input_params => l_input_params);

 sys.UTL_DBWS.release_call (call_handle => l_call);
 sys.UTL_DBWS.release_service (service_handle => l_service);

 RETURN ANYDATA.AccessVarchar2(l_result);
END;

 

以下是wsdl：

 

  <?xml version="1.0" encoding="UTF-8" ?>

- <wsdl:definitions targetNamespace="http://192.168.88.126:8400/axis/BCWebService.jws" xmlns:apachesoap="http://xml.apache.org/xml-soap" xmlns:impl="http://192.168.88.126:8400/axis/BCWebService.jws" xmlns:intf="http://192.168.88.126:8400/axis/BCWebService.jws" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/" xmlns:wsdlsoap="http://schemas.xmlsoap.org/wsdl/soap/" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

- <!--

WSDL created by Apache Axis version: 1.4
Built on Apr 22, 2006 (06:55:48 PDT)

  --> <script></script>

- <wsdl:types>

- <schema targetNamespace="http://192.168.88.126:8400/axis/BCWebService.jws" xmlns="http://www.w3.org/2001/XMLSchema">

  <import namespace="http://schemas.xmlsoap.org/soap/encoding/" />

- <complexType name="ArrayOf_xsd_string">

- <complexContent>

- <restriction base="soapenc:Array">

  <attribute ref="soapenc:arrayType" wsdl:arrayType="xsd:string[]" />

  </restriction>

  </complexContent>

  </complexType>

  </schema>

  </wsdl:types>

- <wsdl:message name="mainRequest">

  <wsdl:part name="args" type="impl:ArrayOf_xsd_string" />

  </wsdl:message>

- <wsdl:message name="validateXMLResponse">

  <wsdl:part name="validateXMLReturn" type="xsd:string" />

  </wsdl:message>

  <wsdl:message name="mainResponse" />

- <wsdl:message name="validateXMLRequest">

   <wsdl:part name="userID" type="xsd:string" />

  <wsdl:part name="password" type="xsd:string" />

    </wsdl:message>

- <wsdl:portType name="BCWebService">

- <wsdl:operation name="main" parameterOrder="args">

  <wsdl:input message="impl:mainRequest" name="mainRequest" />

  <wsdl:output message="impl:mainResponse" name="mainResponse" />

  </wsdl:operation>

- <wsdl:operation name="validateXML" parameterOrder="medicalGroup requestTicket userID password claimDate memberKey1 memberKey2 doctorCode">

  <wsdl:input message="impl:validateXMLRequest" name="validateXMLRequest" />

  <wsdl:output message="impl:validateXMLResponse" name="validateXMLResponse" />

  </wsdl:operation>

  </wsdl:portType>

- <wsdl:binding name="BCWebServiceSoapBinding" type="impl:BCWebService">

  <wsdlsoap:binding style="rpc" transport="http://schemas.xmlsoap.org/soap/http" />

- <wsdl:operation name="main">

  <wsdlsoap:operation soapAction="" />

- <wsdl:input name="mainRequest">

  <wsdlsoap:body encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" namespace="http://DefaultNamespace" use="encoded" />

  </wsdl:input>

- <wsdl:output name="mainResponse">

  <wsdlsoap:body encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" namespace="http://192.168.88.126:8400/axis/BCWebService.jws" use="encoded" />

  </wsdl:output>

  </wsdl:operation>

- <wsdl:operation name="validateXML">

  <wsdlsoap:operation soapAction="" />

- <wsdl:input name="validateXMLRequest">

  <wsdlsoap:body encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" namespace="http://DefaultNamespace" use="encoded" />

  </wsdl:input>

- <wsdl:output name="validateXMLResponse">

  <wsdlsoap:body encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" namespace="http://192.168.88.126:8400/axis/BCWebService.jws" use="encoded" />

  </wsdl:output>

  </wsdl:operation>

  </wsdl:binding>

- <wsdl:service name="BCWebServiceService">

- <wsdl:port binding="impl:BCWebServiceSoapBinding" name="BCWebService">

  <wsdlsoap:address location="http://192.168.88.126:8400/axis/BCWebService.jws" />

  </wsdl:port>

  </wsdl:service>

  </wsdl:definitions>

注意其中蓝色字的对应