Function Element Name is Different than the One Described in the Documentation Guide in Wsdl, in 11.2.0.4 and 11.2.0.3 + Patch 14780408 (Doc ID 1613809.1)

Last updated on FEBRUARY 08, 2017

Applies to:

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

Symptoms

In Oracle Server 11.2.0.4, as well as in Oracle Server 11.2.0.3 with patch 14780408 applied,

the wsdl created for a function have the element name which is no longer respecting the documentation guide:
it should be
<xsd:element name="<OBJECT_TYPE>-<FUNCTION>Input">
while it is
<xsd:element name="<FUNCTION>Input">

Even if the wsdl is changed, the soap request must still written referring to the element name as it is defined in the documentation,
otherwise it raises errors.

Example for a function:

 
it returns a response with errors:
   <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-06550</ErrorNumber>
                   <Message>line 1, column 8:</Message>
                </OracleError>
                <OracleError>
                   <ErrorNumber>PLS-00221</ErrorNumber>
                   <Message>'EXAMPLE_FUNC' is not a procedure or isundefined</Message>
                </OracleError>
                <OracleError>
                   <ErrorNumber>ORA-06550</ErrorNumber>
                   <Message>line 1, column 8: PL/SQL: Statementignored</Message>
                </OracleError>
             </OracleErrors>
          </detail>
       </soap:Fault>
    </soap:Body>
 </soap:Envelope>

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms