Ask a Question

SoapUI set Out Parameter for test soap api

JaimeCarrillo
New Contributor

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 1
JaimeCarrillo
New Contributor

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>

...

cancel
Showing results for 
Search instead for 
Did you mean: