ODI Version XML Driver Incorrectly Identifying Reserved Words In XSD File

(Doc ID 1462171.1)

Last updated on MARCH 08, 2017

Applies to:

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


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

ODI-1228: Task Order (Integration) fails on the target XML connection ....
java.sql.SQLException: java.sql.SQLException: ORA-00933: 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:


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms