Oracle Solution for Error ora-01719
ORA-01719: outer join operator (+) not allowed in operand of OR or IN
What triggered the Error:
An outer join appears in an or clause.What should we do to fix it:
If A and B are predicates, to get the effect of (A(+) or B), try (select where (A(+) and not B)) union all (select where (B)).
If this was not sufficient go over to:
Oracle Official Support Knowledge Center
Or maybe those geeks at: StackOverflow Board
Or maybe those geeks at: StackOverflow Board
