My Oracle Support Banner

ODI Version 11.1.1.3 and 11.1.1.5 XML Driver Incorrectly Identifying Reserved Words In XSD File (Doc ID 1462171.1)

Last updated on FEBRUARY 12, 2019

Applies to:

Oracle Data Integrator - Version 11.1.1.3.0 to 11.1.1.5.0 [Release 11gR1]
Information in this document applies to any platform.

Symptoms

When using XSD (or DTD) files containing reserved words (such as Order, Select, ...) with the Oracle Data Integrator (ODI) 11.1.1.3 and 11.1.1.5 XML Driver in order to reverse engineer the appropriate relational Models, the following message is signaled:

ODI-1228: Task Order (Integration) fails on the target XML connection ....
....
java.sql.SQLException: ORA-00933: SQL command not properly ended
...

Moreover, when tracing the connection to the XML driver it is observed that no alias is created for the ORDER Element:

FIN: Element http://<SERVER NAME>/schema/<NAME> / Order => table ORDER   <<<

Changes

 

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
Changes
Cause
Solution
References


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