ORA-01799: a column may not be outer-joined to a subquery

ORA-01799: a column may not be outer-joined to a subquery


Cause:


(+) () is not allowed.



Action:


Either remove the (+) or make a view out of the subquery. In V6 and before, the (+) was just ignored in this case.