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-1228 ORA-25156: old style outer join (+) cannot be used with ANSI joins

RG 007Nov 11 2012 — edited Nov 14 2012

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

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 12 2012

Added on Nov 11 2012

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

4 comments

10,739 views