My Oracle Support Banner

How to Remove Oracle Error Codes from HTTP Response when Calling Web Service (Doc ID 1938172.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 12.1.0.2 [Release 11.2 to 12.1]
Information in this document applies to any platform.

Goal

How to remove Oracle error texts and codes from HTTP response when calling a database native web service which somehow fails?
Example of HTTP response for errors raised in called PLSQL procedure:

<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-20001</ErrorNumber>
               <Message>This is an error test</Message>
            </OracleError>
            <OracleError>
               <ErrorNumber>ORA-06512</ErrorNumber>
               <Message>at "D2P_BROKER_D.RIB_SERVICE_ENDPOINT", line 3</Message>
            </OracleError>
            <OracleError>
               <ErrorNumber>ORA-06512</ErrorNumber>
               <Message>at "D2PWS.DEMOWS", line 3</Message>
            </OracleError>
            <OracleError>
               <ErrorNumber>ORA-06512</ErrorNumber>
               <Message>at line 1</Message>
            </OracleError>
         </OracleErrors>
      </detail>
   </soap:Fault>
</soap:Body>
</soap:Envelope>

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.