This discussion is archived
0 Replies Latest reply: Sep 9, 2012 3:28 AM by user13046122 RSS

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

user13046122 Newbie
Currently Being Moderated
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="">
<faultstring>Error processing input</faultstring>
<OracleErrors xmlns="">
<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


  • Correct Answers - 10 points
  • Helpful Answers - 5 points