Thursday 19 January 2012

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: lamp;lt;lamp;nbsp;expressionlamp;gt;(+) lamp;lt;lamp;nbsp;reloplamp;gt; (lamp;lt;lamp;nbsp;subquerylamp;gt;) 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.

No comments:

Post a Comment