1 Reply Latest reply: Sep 15, 2013 11:03 PM by tyomasun RSS

    problem utl_dbws  oracle 10.2.0.1

    923990
      create or replace
      FUNCTION add_numbers (p_int_1 IN NUMBER,
      p_int_2 IN NUMBER)
      RETURN NUMBER
      AS
      l_service UTL_DBWS.service;
      l_call UTL_DBWS.call;

      l_wsdl_url VARCHAR2(32767);
      l_namespace VARCHAR2(32767);
      l_service_qname UTL_DBWS.qname;
      l_port_qname UTL_DBWS.qname;
      l_operation_qname UTL_DBWS.qname;

      l_xmltype_in SYS.XMLTYPE;
      l_xmltype_out SYS.XMLTYPE;
      l_return NUMBER;
      BEGIN
      l_wsdl_url := 'http://localhost/server.wsdl';
      l_namespace := 'http://www.oracle-base.com/webservices/';

      l_service_qname := UTL_DBWS.to_qname(l_namespace, 'Calculator');
      l_port_qname := UTL_DBWS.to_qname(l_namespace, 'CalculatorPort');
      l_operation_qname := UTL_DBWS.to_qname(l_namespace, 'ws_add');

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

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

      l_xmltype_in := SYS.XMLTYPE('<?xml version="1.0" encoding="utf-8"?>
      <ws_add xmlns="' || l_namespace || '">
      <int1>' || p_int_1 || '</int1>
      <int2>' || p_int_2 || '</int2>
      </ws_add>');


      l_xmltype_out := UTL_DBWS.invoke(call_Handle => l_call,
      request => l_xmltype_in);

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

      l_return := l_xmltype_out.extract('//return/text()').getNumberVal();*/
      RETURN l_return;
      END;



      Service: oracle.j2ee.ws.client.dii.ConfiguredService@2fbad70a

      *** Created service: -1261915451 - oracle.jpub.runtime.dbws.DbwsProxy$ServiceProxy@7deffd68 ***

      ServiceProxy.get(-1261915451) = oracle.jpub.runtime.dbws.DbwsProxy$ServiceProxy@7deffd68

      Collection Call info: port={http://www.oracle-base.com/webservices/}CalculatorPort, operation={http://www.oracle-base.com/webservices/}ws_add, returnType={http://www.w3.org/2001/XMLSchema}string, params count=2

      java.lang.UnsatisfiedLinkError: oracle.xdb.spi.XDBResource.getServerEnv

           at oracle.xdb.XMLType.initConn(XMLType.java:2294)

           at oracle.xdb.XMLType.<init>(XMLType.java:945)

           at oracle.xdb.XMLType.createXML(XMLType.java:525)

           at oracle.xdb.XMLTypeFactory.create(XMLTypeFactory.java:65)

           at oracle.jdbc.driver.SQLUtil.SQLToJava(SQLUtil.java:232)

           at oracle.sql.SQLUtil.SQLToJava(SQLUtil.java:177)

           at oracle.jdbc.kprb.Conversions.makeOne(Conversions.java:114)

      I can not understand why can not cause
      xdb.jar oracle.xdb.spi.XDBResource.getServerEnv = oracle.exe Javaoracle_xdb_spi_XDBResource_getServerEnv@8

      Edited by: iliya37 on Mar 20, 2012 10:04 PM

      Edited by: iliya37 on Mar 20, 2012 10:07 PM