存储过程调webservice的问题
现需要在存储过程中调用webservice,按照网友的方法,做好准备工作之后,运行报错
ORA-29532: Java 调用被未捕获的 Java 异常错误终止: java.lang.VerifyError: (class: oracle/j2ee/ws/saaj/soap/SOAPDoc, method: getDocumentBuilder signature: ()Loracle/xml/parser/v2/DocumentBuilder;) Wrong return type in function
plsql代码如下
declare
service_ utl_dbws.SERVICE;
l_call utl_dbws.call;
l_result ANYDATA;
l_wsdl_url VARCHAR2(1024);
l_namespace VARCHAR2(200);
l_service VARCHAR2(200);
l_operation_name VARCHAR2(200);
port_qname utl_dbws.QNAME;
service_qname UTL_DBWS.qname;
operation_qname utl_dbws.QNAME;
l_input_params UTL_DBWS.anydata_list;
end_result VARCHAR2(50);
string_type_qname UTL_DBWS.QNAME;
BEGIN
l_wsdl_url := 'http://127.0.0.1:5080/widget/WebService/UserWS?wsdl';
l_namespace:= 'http://webservice.widget.bsj.com/';
l_service:='UserWSService';
l_operation_name := 'getTranslatorUser';
port_qname:=UTL_DBWS.to_qname(l_namespace, 'UserWSPort');
service_qname := UTL_DBWS.to_qname(l_namespace, l_service);
operation_qname := UTL_DBWS.to_qname(l_namespace, l_operation_name);
string_type_qname := UTL_DBWS.to_qname('http://www.w3.org/2001/XMLSchema', 'string');
--service_ := UTL_DBWS.create_service(wsdl_document_location=>urifactory.getUri(l_wsdl_url),service_name=>service_qname);
service_ := UTL_DBWS.create_service(wsdl_document_location=>httpuritype(l_wsdl_url),service_name=>service_qname);
dbms_output.put_line('111');
l_call := UTL_DBWS.create_call(service_handle=>service_,port_name=>null,operation_name=>operation_qname);
utl_dbws.add_parameter(l_call,'portalId',string_type_qname,'ParameterMode.IN');
utl_dbws.add_parameter(l_call,'sysName',string_type_qname,'ParameterMode.IN');
utl_dbws.set_return_type(l_call,string_type_qname);
utl_dbws.set_property(l_call, 'SOAPACTION_USE', 'TRUE');
utl_dbws.set_property(l_call, 'SOAPACTION_URI', '');
l_input_params(0) := ANYDATA.ConvertVarchar2('sysadmin');
l_input_params(1) := ANYDATA.ConvertVarchar2('PLAN');
dbms_output.put_line(ANYDATA.AccessVarchar2(l_input_params(0)));
l_result := UTL_DBWS.invoke(call_Handle=>l_call,input_Params=>l_input_params);
dbms_output.put_line('111');
UTL_DBWS.release_call (call_handle=>l_call);
UTL_DBWS.release_service (service_handle=>service_);
end_result:= ANYDATA.AccessVarchar2(l_result);
dbms_output.put_line(end_result);
EXCEPTION
WHEN OTHERS THEN
--RETURN substr(sqlerrm,0,2000);
dbms_output.put_line('222');
dbms_output.put_line(substr(sqlerrm,0,3000));
END;
执行到红色报错,WSDL如下,谢谢大家了
<wsdl:definitions xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/" xmlns:tns="http://webservice.widget.bsj.com/" xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/" xmlns:ns1="http://schemas.xmlsoap.org/soap/http" name="UserWSService" targetNamespace="http://webservice.widget.bsj.com/">
<wsdl:types>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:tns="http://webservice.widget.bsj.com/" attributeFormDefault="unqualified" elementFormDefault="unqualified" targetNamespace="http://webservice.widget.bsj.com/">
<xs:element name="createUser" type="tns:createUser"/>
<xs:element name="createUserResponse" type="tns:createUserResponse"/>
<xs:element name="getTranslatorUser" type="tns:getTranslatorUser"/>
<xs:element name="getTranslatorUserResponse" type="tns:getTranslatorUserResponse"/>
<xs:complexType name="getTranslatorUser">
<xs:sequence>
<xs:element minOccurs="0" name="portalId" type="xs:string"/>
<xs:element minOccurs="0" name="sysName" type="xs:string"/>
</xs:sequence>
</xs:complexType>
<xs:complexType name="getTranslatorUserResponse">
<xs:sequence>
<xs:element minOccurs="0" name="return" type="xs:string"/>
</xs:sequence>
</xs:complexType>
<xs:complexType name="createUser">
<xs:sequence>
<xs:element minOccurs="0" name="sysId" type="xs:string"/>
<xs:element minOccurs="0" name="userName" type="xs:string"/>
<xs:element minOccurs="0" name="realName" type="xs:string"/>
</xs:sequence>
</xs:complexType>
<xs:complexType name="createUserResponse">
<xs:sequence>
<xs:element name="return" type="xs:int"/>
</xs:sequence>
</xs:complexType>
<xs:element name="Exception" type="tns:Exception"/>
<xs:complexType name="Exception">
<xs:sequence>
<xs:element minOccurs="0" name="message" type="xs:string"/>
</xs:sequence>
</xs:complexType>
</xs:schema>
</wsdl:types>
<wsdl:message name="createUserResponse">
<wsdl:part element="tns:createUserResponse" name="parameters"></wsdl:part>
</wsdl:message>
<wsdl:message name="Exception">
<wsdl:part element="tns:Exception" name="Exception"></wsdl:part>
</wsdl:message>
<wsdl:message name="getTranslatorUserResponse">
<wsdl:part element="tns:getTranslatorUserResponse" name="parameters"></wsdl:part>
</wsdl:message>
<wsdl:message name="createUser">
<wsdl:part element="tns:createUser" name="parameters"></wsdl:part>
</wsdl:message>
<wsdl:message name="getTranslatorUser">
<wsdl:part element="tns:getTranslatorUser" name="parameters"></wsdl:part>
</wsdl:message>
<wsdl:portType name="IUserWS">
<wsdl:operation name="getTranslatorUser">
<wsdl:input message="tns:getTranslatorUser" name="getTranslatorUser"></wsdl:input>
<wsdl:output message="tns:getTranslatorUserResponse" name="getTranslatorUserResponse"></wsdl:output>
<wsdl:fault message="tns:Exception" name="Exception"></wsdl:fault>
</wsdl:operation>
<wsdl:operation name="createUser">
<wsdl:input message="tns:createUser" name="createUser"></wsdl:input>
<wsdl:output message="tns:createUserResponse" name="createUserResponse"></wsdl:output>
<wsdl:fault message="tns:Exception" name="Exception"></wsdl:fault>
</wsdl:operation>
</wsdl:portType>
<wsdl:binding name="UserWSServiceSoapBinding" type="tns:IUserWS">
<soap:binding style="document" transport="http://schemas.xmlsoap.org/soap/http"/>
<wsdl:operation name="getTranslatorUser">
<soap:operation soapAction="" style="document"/>
<wsdl:input name="getTranslatorUser">
<soap:body use="literal"/>
</wsdl:input>
<wsdl:output name="getTranslatorUserResponse">
<soap:body use="literal"/>
</wsdl:output>
<wsdl:fault name="Exception">
<soap:fault name="Exception" use="literal"/>
</wsdl:fault>
</wsdl:operation>
<wsdl:operation name="createUser">
<soap:operation soapAction="" style="document"/>
<wsdl:input name="createUser">
<soap:body use="literal"/>
</wsdl:input>
<wsdl:output name="createUserResponse">
<soap:body use="literal"/>
</wsdl:output>
<wsdl:fault name="Exception">
<soap:fault name="Exception" use="literal"/>
</wsdl:fault>
</wsdl:operation>
</wsdl:binding>
<wsdl:service name="UserWSService">
<wsdl:port binding="tns:UserWSServiceSoapBinding" name="UserWSPort">
<soap:address location="http://localhost:5080/widget/WebService/UserWS"/>
</wsdl:port>
</wsdl:service>
</wsdl:definitions>