Cannot Invoke Custom Service When Using Lower Case Parameter Names (Doc ID 2802250.1)

Last updated on AUGUST 23, 2023

Applies to:

Symptoms

Client has created a REST service based on PL/SQL API and deployed it to Oracle ISG.
The PL/SQL API has input parameters based on various object types, the problem we are facing is that all in input parameters of the PL/SQL procedure appear in uppercase only in the XSD.
Is there any way to make it lower case or mixed case?

Steps to recreate this issue:

1. Create a Custom REST Web Service, where defined input parameters are in mixed case (Support has no Notes/Documentation on doing this)
      a. Creation of any Custom Web Service will generate an associated XSD file (XML schema definition)

2. Invoke the Custom Web Service

3. After invoking will notice the Input Parameters are all in upper case

4. As a result the values specified for these input parameters are not sent, causing the specific procedure to fail

Cause

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