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 MARCH 28, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
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
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
| Symptoms |
| Cause |
| Solution |
| References |