My Oracle Support Banner

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

Last updated on MARCH 28, 2019

Applies to:

Oracle Database - Enterprise Edition - Version to [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.


In Oracle Server, as well as in Oracle Server 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="">
          <faultstring>Error processing input</faultstring>
             <OracleErrors xmlns="">
                   <Message>Error occurred in XML processing</Message>
                   <Message>line 1, column 8:</Message>
                   <Message>'EXAMPLE_FUNC' is not a procedure or isundefined</Message>
                   <Message>line 1, column 8: PL/SQL: Statementignored</Message>


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

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