This discussion is archived
1 Reply Latest reply: Oct 18, 2011 9:51 PM by ThetchinamoorthyGanesan RSS

ODI -1228 - Error while writing data into Integration Tool

894315 Newbie
Currently Being Moderated
Dear Concern,

We are getting the following error while running the interface in ODI:

ODI-1228: Task int_jda_loc (Integration) fails on the target ORACLE connection ORCL_JDADVDB.
Caused By: java.sql.SQLSyntaxErrorException: ORA-01790: expression must have same datatype as corresponding expression.

Please suggest your thoughts and suggestion on the same.. how to resolve the above issue... as it is not telling which column datatype is not matched !!!


  • Correct Answers - 10 points
  • Helpful Answers - 5 points