My Oracle Support Banner

XSD Created for DBAdapter Which Is Based On Object In Schema Name Like OPS$XXXX Results In Invalid XSD (Doc ID 1581403.1)

Last updated on MARCH 21, 2019

Applies to:

Oracle SOA Suite - Version and later
Information in this document applies to any platform.


  1. When a DBAdapter is created in JDeveloper to call a Procedure, and this procedure uses a database type from a username in a this format: OPS$XXX, the generated XML schema file will have the '$' in the name of the type.  The result of this is to make the generated XSD file invalid.
  2. The issue also reproduces in the following scenario described below:

    If DB adapter used as query having special characters, error occurs in generated xsd.
    SELECT TRUNC(SYSDATE) FROM DUAL the variable at the generated schema will be "TRUNC(SYSDATE)" - this also results in the generated XSD error being invalid.




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.