4 Replies Latest reply: Nov 14, 2012 9:07 AM by RG 007 RSS

    ODI-1228 ORA-25156: old style outer join (+) cannot be used with ANSI joins

    RG 007
      Hi Gurus,

      I am using ODI 11g, with Oracle 11g, I have source, staging and target on same database but different schema.
      I have an interface with two lookups into dimension tables.

      When I run my interface I am getting below error.
      Just wondering can we resolve it from ODI only, or Oracle DBA needs to change some settings.
      I will prefer to resolve this from ODI only.
      Error*
      ODI-1228: Task 2 ODI_source_table (Integration) fails on the target ORACLE connection conn1.
      Caused By: java.sql.SQLException: ORA-25156: old style outer join (+) cannot be used with ANSI joins

      I will really appreciate in advice on this..
      Thanks