Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODI-1227: unexpected token

SambuuFeb 27 2019 — edited Mar 4 2019

I'm inserting XML file to Oracle Database. But some of my XML model table's column named "NUMBER". In Oracle database, i know column couldn't named as "NUMBER".

In ODI 11g, i'm resolved this issue by rename column in target model. But ODI 12, this solution doesn't work anymore. It gives me ODI-1227 unexpected token: NUMBER_.

My data can't load C$_ table.

Here's my source model:

Here's my target Model:

Here's my mapping:

Here's log error:

How to resolve this problem?

This post has been answered by Sambuu on Mar 4 2019

Jump to Answer

Added on Feb 27 2019

#business-intelligence-applications, #data-integrator, #system-management-and-integration

7 comments

656 views