Forum Discussion

JaimeCarrillo's avatar
JaimeCarrillo
New Contributor
11 months ago

SoapUI set Out Parameter for test soap api

I have an API that execute an Oracle Procedure and it includes an Out parameter. When I execute the api I include all parameters (3) the first 2 with data to work and the 3rd is to receive an answer. The result is showing me: "<faultstring>java.sql.SQLException: Missing IN or OUT parameter at index:: 2</faultstring> ".

How I set the OUT parameter from xml. I have the next XML:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:web="http://webservice.....">
<soapenv:Header/>
<soapenv:Body>
<web:executeCustomTransaction>
<!--Optional:-->
<web:transactionCode>ExecProcedure</web:transactionCode>
<!--Zero or more repetitions:-->
<web:transactionParameters>
<web:fieldName>Param1</web:fieldName>
<web:fieldValue>77777</web:fieldValue>

<web:fieldName>Param2</web:fieldName>
<web:fieldValue>XXXXX</web:fieldValue>

<web:fieldName>Param3</web:fieldName>
<web:fieldValue>0</web:fieldValue>
</web:transactionParameters>
</web:executeCustomTransaction>
</soapenv:Body>
</soapenv:Envelope>

1 Reply

Sort By
  • JaimeCarrillo's avatar
    JaimeCarrillo
    New Contributor
    11 months ago

    I found the fail for it and now it's working. Every parameter has to be in this way:

    <web:transactionParameters>

       <web:fieldName>Param1</web:fieldName>
       <web:fieldValue>77777</web:fieldValue>

    </web:transactionParameters>

    <web:transactionParameters>

      <web:fieldName>Param2</web:fieldName>
      <web:fieldValue>XXXX</web:fieldValue>

    </web:transactionParameters>

    ...