0 Replies Latest reply: Sep 9, 2012 5:28 AM by user13046122 RSS

    SOAP Fault when returning null from a Native Web Service Stored Procedure

    user13046122
      I have a stored procedure which I can successfully invoke via soapUI
      However, if one of the Stored Procedure's OUT arguments is set to null the native web service returns the following fault :
      <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
      <soap:Body>
      <soap:Fault>
      <faultcode>soap:Client</faultcode>
      <faultstring>Error processing input</faultstring>
      <detail>
      <OracleErrors xmlns="http://xmlns.oracle.com/orawsv/faults">
      <OracleError>
      <ErrorNumber>ORA-19202</ErrorNumber>
      <Message>Error occurred in XML processing</Message>
      </OracleError>
      <OracleError>
      <ErrorNumber>ORA-01405</ErrorNumber>
      <Message>fetched column value is NULL</Message>
      </OracleError>
      </OracleErrors>
      </detail>
      </soap:Fault>
      </soap:Body>
      </soap:Envelope>
      I can see how to control the processing of null values when invoking orawsv (using the null_handling element).
      Is there an equivalent for Stored Procedures ?

      Thanks,

      PD

      versions as follows :
      Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
      PL/SQL Release 11.2.0.1.0 - Production
      "CORE     11.2.0.1.0     Production"
      TNS for Linux: Version 11.2.0.1.0 - Production
      NLSRTL Version 11.2.0.1.0 - Production