ORA-01417
Error: ORA-01417: a table may be outer joined to at most one other table
Causa: a.b (+) = b.b and a.c (+) = c.c is not allowed.
Acción: Check that this is really what you want, then join b and c first in a view.
COMENTARIOS:
por Andres ALvarez C. | 12/03/2008 14:35:49
RE: ORA-01417
Si tienes en la clausula WHERE:
A.X(+) = B.X
AND A.Y(+) = C.Y
ERROR: a table may be outer joined to at most one other table
Ver la manera de unir en una vista o subquery (dentro de la clausula FROM) las dos tablas que hace referencia a tabla con outer joins. ES DECIR:
(SELECT
X,
Y
FROM
B,
C
WHERE
C.Z = B.Z
) E
Quedando:
SELECT
A.X,
A.Y
FROM
A,
B,
(SELECT
X,
Y
FROM
B,
C
WHERE
C.Z = B.Z
) E
WHERE
A.X(+) = E.X
AND A.Y(+) = E.Y
ANDRESNEO: ANDRESNEO@GMAIL.COM