ORA-01719: outer join operator(+) not allowed in operand of OR or IN
442803Sep 11 2006 — edited Sep 11 2006Hi All,
My discoverer report generated error message "ORA-01719: outer join operator(+) not allowed in operand of OR or IN" when running it from folder that has outer join on detail. By detail, this report is created by two folder A and B
I join it with one-to-many releationship; outer join on detail A --> B(+)
in report I create condition from table B(detail) with NOT BETWEEN operator.
When run this report it generated error msg. as I said above ,I try to change operator to lower than (<) and greater than(>) so it can solve this problem.
Anyone can tell me what is the reason about this event? why the report doesn't generate error?
Thank you,
Mcka