ORA-29541: class SYS.oracle/jpub/runtime/dbws/DbwsProxy could not be resolved

在oracle10.1.2中用function调用webservcie出现如下错误：

"ORA-29541: class SYS.oracle/jpub/runtime/dbws/DbwsProxy could not be resolved"

 

这是因为需要导入一些包（详情可参考http://www.oracle-base.com/articles/10g/utl_dbws10g.php）

First, download the latest copy of the dbwsclient.jar file:

• Pre 10g: dbws-callout-utility.zip (10.1.2)
• 10g: dbws-callout-utility-10R2.zip (10.1.3.0)
• 10g & 11g latest: dbws-callout-utility-10131.zip (10.1.3.1)

Extract the jar file from the zip file into the $ORACLE_HOME/sqlj/lib directory.

 

 # Load into the SYS schema.
export PATH=/u01/app/oracle/product/10.2.0/db_1/bin:$PATH
cd /u01/app/oracle/product/10.2.0/db_1/sqlj/lib
# 10gR2
loadjava -u sys/password -r -v -f -genmissing -s -grant public dbwsclientws.jar

# 11g
loadjava -u sys/password -r -v -f -genmissing -s -grant public dbwsclientws.jar

原文中提到也可以导入单个的schema，但是我导入后还是有问题。In Oracle 10g the UTL_DBWS package is loaded by default，所以我就用sys.UTL_DBWS.

我下载的是第二个包。

在导入的过程中正常情况下没有错误，那就要恭喜你了。可是事与愿违，经常会产生错误，所以当运行webservice代码时还会报上面的错误！！！

解决如下：

解压dbwsclientws.jar 找到oracle下的jpub/runtime/dbws整个目录，拷贝出来，重新打包，再重新单独导入这个包即可。将我重新打包的jar上传一下（看附件）

 

loadjava -u sys/password -r -v -f -genmissing -s -grant public dbwsproxy.jar

 

示例：

以下是我的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 =" medicalGroup " type =" xsd:string " />

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

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

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

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

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

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

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

  </ wsdl:message >

- < wsdl:portType name =" BCWebService ">

- < 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:operation name =" main " parameterOrder =" args ">

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

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

  </ 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 =" 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: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: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 >

下面是oracle function：

-------------------------------------------------------------------------------------

create or replace
FUNCTION get_city_from_zipcode (p_zipcode  IN  VARCHAR2)
  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_input_params(2) := ANYDATA.ConvertVarchar2('11111111');
     l_input_params(3) := ANYDATA.ConvertVarchar2('11111111');
      l_input_params(4) := ANYDATA.ConvertVarchar2('20091103');
       l_input_params(5) := ANYDATA.ConvertVarchar2('11111111');
        l_input_params(6) := ANYDATA.ConvertVarchar2('11111111');
         l_input_params(7) := ANYDATA.ConvertVarchar2('55555');
 
  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;

 ---------------------------------------------------------------------------------------------------------------------

 

执行成功！