C # Consume Oracle Web Service Return Null

0

Good I have a quite big problem that has taken me Days of Days and I continue in the investigation

I try the WSDL from the SoapUI and everything Marcha to perfection.

but when trying to consume from .net C #

the query sends the parameters because I see the log on the server oracle

but I always return Null or empty fields

here the WSDL attached

    <?xml version="1.0" encoding="utf-8"?>
<definitions xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/" xmlns:tns0="http://to.ws.cia.gdis.movilnet.com.ve/types/" xmlns:tns="http://services.serials.base.ws.cia.gdis.movilnet.com.ve/" xmlns:mime="http://schemas.xmlsoap.org/wsdl/mime/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap12="http://schemas.xmlsoap.org/wsdl/soap12/" name="WSBaseSerials" targetNamespace="http://services.serials.base.ws.cia.gdis.movilnet.com.ve/" xmlns="http://schemas.xmlsoap.org/wsdl/">
  <types>
    <xsd:schema xmlns="http://www.w3.org/2001/XMLSchema" xmlns:tns="http://to.ws.cia.gdis.movilnet.com.ve/types/" xmlns:soap11-enc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" elementFormDefault="qualified" targetNamespace="http://to.ws.cia.gdis.movilnet.com.ve/types/">
      <xsd:import namespace="http://schemas.xmlsoap.org/soap/encoding/" />
      <xsd:import namespace="http://schemas.xmlsoap.org/wsdl/" />
      <xsd:complexType name="CheckLinesRequestTO">
        <xsd:complexContent mixed="false">
          <xsd:extension base="tns:RequestTO">
            <xsd:sequence>
              <xsd:element name="celularesList" type="tns:ArrayOflong" />
            </xsd:sequence>
          </xsd:extension>
        </xsd:complexContent>
      </xsd:complexType>
      <xsd:complexType name="RequestTO">
        <xsd:sequence>
          <xsd:element name="applicationClient" type="tns:ApplicationClientTO" />
          <xsd:element name="security" type="tns:SecurityTO" />
          <xsd:element name="serviceProvider" type="xsd:string" />
          <xsd:element name="technology" type="xsd:short" />
          <xsd:element name="transactionId" type="xsd:string" />
        </xsd:sequence>
      </xsd:complexType>
      <xsd:complexType name="ApplicationClientTO">
        <xsd:sequence>
          <xsd:element name="application" type="xsd:string" />
          <xsd:element name="code" type="xsd:string" />
        </xsd:sequence>
      </xsd:complexType>
      <xsd:complexType name="SecurityTO">
        <xsd:sequence>
          <xsd:element name="ccwsPassword" type="xsd:string" />
          <xsd:element name="ccwsUser" type="xsd:string" />
        </xsd:sequence>
      </xsd:complexType>
      <xsd:complexType name="ValidDCAndDVRequestTO">
        <xsd:complexContent mixed="false">
          <xsd:extension base="tns:RequestTO">
            <xsd:sequence>
              <xsd:element name="celularType" type="xsd:string" />
              <xsd:element name="dealerCode" type="xsd:string" />
              <xsd:element name="eqpCompOwnershipInd" type="xsd:string" />
              <xsd:element name="eqpCtvCompOwnershipInd" type="xsd:string" />
              <xsd:element name="serial" type="xsd:string" />
              <xsd:element name="simcard" type="xsd:string" />
            </xsd:sequence>
          </xsd:extension>
        </xsd:complexContent>
      </xsd:complexType>
      <xsd:complexType name="IsValidSuperUserRequestTO">
        <xsd:complexContent mixed="false">
          <xsd:extension base="tns:RequestTO">
            <xsd:sequence>
              <xsd:element name="clientType" type="xsd:string" />
              <xsd:element name="userId" type="xsd:string" />
            </xsd:sequence>
          </xsd:extension>
        </xsd:complexContent>
      </xsd:complexType>
      <xsd:complexType name="CheckSuperUserRequestTO">
        <xsd:complexContent mixed="false">
          <xsd:extension base="tns:RequestTO">
            <xsd:sequence>
              <xsd:element name="aplicationType" type="xsd:string" />
              <xsd:element name="customerType" type="xsd:string" />
              <xsd:element name="genField1" type="xsd:string" />
              <xsd:element name="ssn" type="xsd:string" />
              <xsd:element name="transactionType" type="xsd:string" />
              <xsd:element name="userId" type="xsd:string" />
            </xsd:sequence>
          </xsd:extension>
        </xsd:complexContent>
      </xsd:complexType>
      <xsd:complexType name="ValidSerialStockRequestTO">
        <xsd:complexContent mixed="false">
          <xsd:extension base="tns:RequestTO">
            <xsd:sequence>
              <xsd:element name="formatoSerialHandset" type="xsd:string" />
              <xsd:element name="serial" type="xsd:string" />
              <xsd:element name="simcard" type="xsd:string" />
              <xsd:element name="userId" type="xsd:string" />
            </xsd:sequence>
          </xsd:extension>
        </xsd:complexContent>
      </xsd:complexType>
      <xsd:complexType name="GetSerialEquipmentRequestTO">
        <xsd:complexContent mixed="false">
          <xsd:extension base="tns:RequestTO">
            <xsd:sequence>
              <xsd:element name="aplicationType" type="xsd:string" />
              <xsd:element name="param" type="tns:ArrayOfstring" />
              <xsd:element name="serialEq" type="xsd:string" />
              <xsd:element name="serialSim" type="xsd:string" />
            </xsd:sequence>
          </xsd:extension>
        </xsd:complexContent>
      </xsd:complexType>
      <xsd:complexType name="ArrayOfstring">
        <xsd:complexContent mixed="false">
          <xsd:restriction base="soap11-enc:Array">
            <xsd:sequence>
              <xsd:element name="item" type="xsd:string" />
            </xsd:sequence>
            <xsd:attribute wsdl:arrayType="xsd:string[]" ref="soap11-enc:arrayType" />
          </xsd:restriction>
        </xsd:complexContent>
      </xsd:complexType>
      <xsd:complexType name="ValidSerialRequestTO">
        <xsd:complexContent mixed="false">
          <xsd:extension base="tns:RequestTO">
            <xsd:sequence>
              <xsd:element name="formatoSerialHandset" type="xsd:string" />
              <xsd:element name="serial" type="xsd:string" />
              <xsd:element name="simcard" type="xsd:string" />
              <xsd:element name="userId" type="xsd:string" />
            </xsd:sequence>
          </xsd:extension>
        </xsd:complexContent>
      </xsd:complexType>
      <xsd:complexType name="ValidSerialNegativeRequestTO">
        <xsd:complexContent mixed="false">
          <xsd:extension base="tns:RequestTO">
            <xsd:sequence>
              <xsd:element name="serial" type="xsd:string" />
              <xsd:element name="simcard" type="xsd:string" />
            </xsd:sequence>
          </xsd:extension>
        </xsd:complexContent>
      </xsd:complexType>
      <xsd:complexType name="ArrayOflong">
        <xsd:complexContent mixed="false">
          <xsd:restriction base="soap11-enc:Array">
            <xsd:sequence>
              <xsd:element name="item" type="xsd:long" />
            </xsd:sequence>
            <xsd:attribute wsdl:arrayType="xsd:long[]" ref="soap11-enc:arrayType" />
          </xsd:restriction>
        </xsd:complexContent>
      </xsd:complexType>
      <xsd:complexType name="IntResponseTO">
        <xsd:complexContent mixed="false">
          <xsd:extension base="tns:ResponseTO">
            <xsd:sequence>
              <xsd:element name="value" type="xsd:int" />
            </xsd:sequence>
          </xsd:extension>
        </xsd:complexContent>
      </xsd:complexType>
      <xsd:complexType name="ResponseTO">
        <xsd:sequence>
          <xsd:element name="executionTime" type="xsd:long" />
          <xsd:element name="origin" type="xsd:string" />
          <xsd:element name="responseCode" type="xsd:string" />
          <xsd:element name="responseDescription" type="xsd:string" />
          <xsd:element name="responseMessage" type="xsd:string" />
          <xsd:element name="responseSubCode" type="xsd:string" />
          <xsd:element name="transactionId" type="xsd:string" />
        </xsd:sequence>
      </xsd:complexType>
      <xsd:complexType name="ValidDCAndDVResponseTO">
        <xsd:complexContent mixed="false">
          <xsd:extension base="tns:ResponseTO">
            <xsd:sequence>
              <xsd:element name="equipoNuevoInd" type="xsd:string" />
              <xsd:element name="simNuevoInd" type="xsd:string" />
            </xsd:sequence>
          </xsd:extension>
        </xsd:complexContent>
      </xsd:complexType>
      <xsd:complexType name="GetSerialEquipmentResponseTO">
        <xsd:complexContent mixed="false">
          <xsd:extension base="tns:ResponseTO">
            <xsd:sequence>
              <xsd:element name="equTypEq" type="xsd:string" />
              <xsd:element name="equTypSim" type="xsd:string" />
              <xsd:element name="param" type="tns:ArrayOfstring" />
            </xsd:sequence>
          </xsd:extension>
        </xsd:complexContent>
      </xsd:complexType>
      <xsd:complexType name="ValidSerialResponseTO">
        <xsd:complexContent mixed="false">
          <xsd:extension base="tns:ResponseTO">
            <xsd:sequence>
              <xsd:element name="celularesList" type="tns:ArrayOflong" />
              <xsd:element name="celularesSimList" type="tns:ArrayOflong" />
              <xsd:element name="esnSuperUserInd" type="xsd:boolean" />
              <xsd:element name="ocurrencyHandset" type="xsd:int" />
              <xsd:element name="ocurrencySimcard" type="xsd:int" />
              <xsd:element name="simSuperUserInd" type="xsd:boolean" />
            </xsd:sequence>
          </xsd:extension>
        </xsd:complexContent>
      </xsd:complexType>
      <xsd:complexType name="ValidSerialStockResponseTO">
        <xsd:complexContent mixed="false">
          <xsd:extension base="tns:ResponseTO">
            <xsd:sequence>
              <xsd:element name="capacidadEvdoInd" type="xsd:string" />
              <xsd:element name="capacidadGpsInd" type="xsd:string" />
              <xsd:element name="capacityMms" type="xsd:string" />
              <xsd:element name="eqpCompanyOwnershipInd" type="xsd:string" />
              <xsd:element name="eqpCtvCompOwnershipInd" type="xsd:string" />
              <xsd:element name="eqpTecnologyValue" type="xsd:string" />
              <xsd:element name="imsi" type="xsd:long" />
              <xsd:element name="itemCatId" type="xsd:string" />
              <xsd:element name="itemSubcatId" type="xsd:string" />
              <xsd:element name="phoneTypeDesc" type="xsd:string" />
              <xsd:element name="phoneTypeId" type="xsd:string" />
              <xsd:element name="simTecnologyValue" type="xsd:string" />
            </xsd:sequence>
          </xsd:extension>
        </xsd:complexContent>
      </xsd:complexType>
      <xsd:complexType name="IsValidSuperUserResponseTO">
        <xsd:complexContent mixed="false">
          <xsd:extension base="tns:ResponseTO">
            <xsd:sequence>
              <xsd:element name="ciSuperUserInd" type="xsd:string" />
            </xsd:sequence>
          </xsd:extension>
        </xsd:complexContent>
      </xsd:complexType>
      <xsd:complexType name="BooleanResponseTO">
        <xsd:complexContent mixed="false">
          <xsd:extension base="tns:ResponseTO">
            <xsd:sequence>
              <xsd:element name="result" type="xsd:boolean" />
            </xsd:sequence>
          </xsd:extension>
        </xsd:complexContent>
      </xsd:complexType>
      <xsd:complexType name="CheckSuperUserResponseTO">
        <xsd:complexContent mixed="false">
          <xsd:extension base="tns:ResponseTO">
            <xsd:sequence>
              <xsd:element name="genField1" type="xsd:string" />
            </xsd:sequence>
          </xsd:extension>
        </xsd:complexContent>
      </xsd:complexType>
    </xsd:schema>
  </types>
  <message name="IWSBaseSerials_checkLines">
    <part name="checkSerialsRequest" type="tns0:CheckLinesRequestTO" />
  </message>
  <message name="IWSBaseSerials_checkLinesResponse">
    <part name="result" type="tns0:IntResponseTO" />
  </message>
  <message name="IWSBaseSerials_checkSuperUser">
    <part name="request" type="tns0:CheckSuperUserRequestTO" />
  </message>
  <message name="IWSBaseSerials_checkSuperUserResponse">
    <part name="result" type="tns0:CheckSuperUserResponseTO" />
  </message>
  <message name="IWSBaseSerials_getSerialEquipment">
    <part name="request" type="tns0:GetSerialEquipmentRequestTO" />
  </message>
  <message name="IWSBaseSerials_getSerialEquipmentResponse">
    <part name="result" type="tns0:GetSerialEquipmentResponseTO" />
  </message>
  <message name="IWSBaseSerials_isSerialInStock">
    <part name="validSerialStockRequest" type="tns0:ValidSerialStockRequestTO" />
  </message>
  <message name="IWSBaseSerials_isSerialInStockResponse">
    <part name="result" type="tns0:ValidSerialStockResponseTO" />
  </message>
  <message name="IWSBaseSerials_isSerialNegative">
    <part name="validSerialNegativeRequest" type="tns0:ValidSerialNegativeRequestTO" />
  </message>
  <message name="IWSBaseSerials_isSerialNegativeResponse">
    <part name="result" type="tns0:BooleanResponseTO" />
  </message>
  <message name="IWSBaseSerials_isValidSerial">
    <part name="validSerialRequest" type="tns0:ValidSerialRequestTO" />
  </message>
  <message name="IWSBaseSerials_isValidSerialResponse">
    <part name="result" type="tns0:ValidSerialResponseTO" />
  </message>
  <message name="IWSBaseSerials_isValidSerialPost">
    <part name="validSerialRequest" type="tns0:ValidSerialRequestTO" />
  </message>
  <message name="IWSBaseSerials_isValidSerialPostResponse">
    <part name="result" type="tns0:ValidSerialResponseTO" />
  </message>
  <message name="IWSBaseSerials_isValidSuperUser">
    <part name="request" type="tns0:IsValidSuperUserRequestTO" />
  </message>
  <message name="IWSBaseSerials_isValidSuperUserResponse">
    <part name="result" type="tns0:IsValidSuperUserResponseTO" />
  </message>
  <message name="IWSBaseSerials_validDCAndDV">
    <part name="validDCAndDVRequest" type="tns0:ValidDCAndDVRequestTO" />
  </message>
  <message name="IWSBaseSerials_validDCAndDVResponse">
    <part name="result" type="tns0:ValidDCAndDVResponseTO" />
  </message>
  <portType name="WSBaseSerials">
    <operation name="checkLines" parameterOrder="checkSerialsRequest">
      <input message="tns:IWSBaseSerials_checkLines" />
      <output message="tns:IWSBaseSerials_checkLinesResponse" />
    </operation>
    <operation name="checkSuperUser" parameterOrder="request">
      <input message="tns:IWSBaseSerials_checkSuperUser" />
      <output message="tns:IWSBaseSerials_checkSuperUserResponse" />
    </operation>
    <operation name="getSerialEquipment" parameterOrder="request">
      <input message="tns:IWSBaseSerials_getSerialEquipment" />
      <output message="tns:IWSBaseSerials_getSerialEquipmentResponse" />
    </operation>
    <operation name="isSerialInStock" parameterOrder="validSerialStockRequest">
      <input message="tns:IWSBaseSerials_isSerialInStock" />
      <output message="tns:IWSBaseSerials_isSerialInStockResponse" />
    </operation>
    <operation name="isSerialNegative" parameterOrder="validSerialNegativeRequest">
      <input message="tns:IWSBaseSerials_isSerialNegative" />
      <output message="tns:IWSBaseSerials_isSerialNegativeResponse" />
    </operation>
    <operation name="isValidSerial" parameterOrder="validSerialRequest">
      <input message="tns:IWSBaseSerials_isValidSerial" />
      <output message="tns:IWSBaseSerials_isValidSerialResponse" />
    </operation>
    <operation name="isValidSerialPost" parameterOrder="validSerialRequest">
      <input message="tns:IWSBaseSerials_isValidSerialPost" />
      <output message="tns:IWSBaseSerials_isValidSerialPostResponse" />
    </operation>
    <operation name="isValidSuperUser" parameterOrder="request">
      <input message="tns:IWSBaseSerials_isValidSuperUser" />
      <output message="tns:IWSBaseSerials_isValidSuperUserResponse" />
    </operation>
    <operation name="validDCAndDV" parameterOrder="validDCAndDVRequest">
      <input message="tns:IWSBaseSerials_validDCAndDV" />
      <output message="tns:IWSBaseSerials_validDCAndDVResponse" />
    </operation>
  </portType>
  <binding name="WSBaseSerialsSoapHttp" type="tns:WSBaseSerials">
    <soap:binding transport="http://schemas.xmlsoap.org/soap/http" style="rpc" />
    <operation name="checkLines">
      <soap:operation soapAction="http://services.serials.base.ws.cia.gdis.movilnet.com.ve//checkLines" />
      <input>
        <soap:body use="encoded" namespace="http://services.serials.base.ws.cia.gdis.movilnet.com.ve/" encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" parts="checkSerialsRequest" />
      </input>
      <output>
        <soap:body use="encoded" namespace="http://services.serials.base.ws.cia.gdis.movilnet.com.ve/" encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" parts="result" />
      </output>
    </operation>
    <operation name="checkSuperUser">
      <soap:operation soapAction="http://services.serials.base.ws.cia.gdis.movilnet.com.ve//checkSuperUser" />
      <input>
        <soap:body use="encoded" namespace="http://services.serials.base.ws.cia.gdis.movilnet.com.ve/" encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" parts="request" />
      </input>
      <output>
        <soap:body use="encoded" namespace="http://services.serials.base.ws.cia.gdis.movilnet.com.ve/" encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" parts="result" />
      </output>
    </operation>
    <operation name="getSerialEquipment">
      <soap:operation soapAction="http://services.serials.base.ws.cia.gdis.movilnet.com.ve//getSerialEquipment" />
      <input>
        <soap:body use="encoded" namespace="http://services.serials.base.ws.cia.gdis.movilnet.com.ve/" encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" parts="request" />
      </input>
      <output>
        <soap:body use="encoded" namespace="http://services.serials.base.ws.cia.gdis.movilnet.com.ve/" encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" parts="result" />
      </output>
    </operation>
    <operation name="isSerialInStock">
      <soap:operation soapAction="http://services.serials.base.ws.cia.gdis.movilnet.com.ve//isSerialInStock" />
      <input>
        <soap:body use="encoded" namespace="http://services.serials.base.ws.cia.gdis.movilnet.com.ve/" encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" parts="validSerialStockRequest" />
      </input>
      <output>
        <soap:body use="encoded" namespace="http://services.serials.base.ws.cia.gdis.movilnet.com.ve/" encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" parts="result" />
      </output>
    </operation>
    <operation name="isSerialNegative">
      <soap:operation soapAction="http://services.serials.base.ws.cia.gdis.movilnet.com.ve//isSerialNegative" />
      <input>
        <soap:body use="encoded" namespace="http://services.serials.base.ws.cia.gdis.movilnet.com.ve/" encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" parts="validSerialNegativeRequest" />
      </input>
      <output>
        <soap:body use="encoded" namespace="http://services.serials.base.ws.cia.gdis.movilnet.com.ve/" encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" parts="result" />
      </output>
    </operation>
    <operation name="isValidSerial">
      <soap:operation soapAction="http://services.serials.base.ws.cia.gdis.movilnet.com.ve//isValidSerial" />
      <input>
        <soap:body use="encoded" namespace="http://services.serials.base.ws.cia.gdis.movilnet.com.ve/" encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" parts="validSerialRequest" />
      </input>
      <output>
        <soap:body use="encoded" namespace="http://services.serials.base.ws.cia.gdis.movilnet.com.ve/" encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" parts="result" />
      </output>
    </operation>
    <operation name="isValidSerialPost">
      <soap:operation soapAction="http://services.serials.base.ws.cia.gdis.movilnet.com.ve//isValidSerialPost" />
      <input>
        <soap:body use="encoded" namespace="http://services.serials.base.ws.cia.gdis.movilnet.com.ve/" encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" parts="validSerialRequest" />
      </input>
      <output>
        <soap:body use="encoded" namespace="http://services.serials.base.ws.cia.gdis.movilnet.com.ve/" encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" parts="result" />
      </output>
    </operation>
    <operation name="isValidSuperUser">
      <soap:operation soapAction="http://services.serials.base.ws.cia.gdis.movilnet.com.ve//isValidSuperUser" />
      <input>
        <soap:body use="encoded" namespace="http://services.serials.base.ws.cia.gdis.movilnet.com.ve/" encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" parts="request" />
      </input>
      <output>
        <soap:body use="encoded" namespace="http://services.serials.base.ws.cia.gdis.movilnet.com.ve/" encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" parts="result" />
      </output>
    </operation>
    <operation name="validDCAndDV">
      <soap:operation soapAction="http://services.serials.base.ws.cia.gdis.movilnet.com.ve//validDCAndDV" />
      <input>
        <soap:body use="encoded" namespace="http://services.serials.base.ws.cia.gdis.movilnet.com.ve/" encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" parts="validDCAndDVRequest" />
      </input>
      <output>
        <soap:body use="encoded" namespace="http://services.serials.base.ws.cia.gdis.movilnet.com.ve/" encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" parts="result" />
      </output>
    </operation>
  </binding>
  <service name="WSBaseSerials">
    <port name="serial" binding="tns:WSBaseSerialsSoapHttp">
      <soap:address location="http://161.196.198.36:7777/wsbaseserial/serial" />
    </port>
  </service>
</definitions>
    
asked by Marthianfred 02.03.2017 в 17:27
source

0 answers