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

      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/">
      <faultstring>Error processing input</faultstring>
      <OracleErrors xmlns="http://xmlns.oracle.com/orawsv/faults">
      <Message>Error occurred in XML processing</Message>
      <Message>fetched column value is NULL</Message>
      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 ?



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