oci_execute(): ORA-01799: a column may not be outer-joined to a subquery |
A strange thing occour when execute sql using oci8. oci_execute(): ORA-01799: a column may not be outer-joined to a subquery. However, this same sql is executed correctly in dbeaver tool. The problem occour in left join clause.
follow sql code: SELECT CO_SEQ_MANIFESTACAO FROM DBOUVIDOR.TB_MANIFESTACAO M INNER JOIN DBOUVIDOR.TB_CLASSIFICACAO_MANIFESTACAO CLASS_MANIF ON (CLASS_MANIF.CO_SEQ_CLASSIF_MANIFESTACAO = M.CO_CLASSIFICACAO_MANIFESTACAO) INNER JOIN DBOUVIDOR.TB_TIPO_MANIFESTACAO TP_MANIF ON (TP_MANIF.CO_SEQ_TIPO_MANIFESTACAO = CLASS_MANIF.CO_TIPO_MANIFESTACAO) LEFT JOIN DBOUVIDOR.TB_ACOMPANHAMENTO_MANIFESTACAO MANIF_ATUAL ON (MANIF_ATUAL.CO_MANIFESTACAO = M.CO_SEQ_MANIFESTACAO AND MANIF_ATUAL.CO_SEQ_ACOMPANHAMENTO IN (SELECT MAX(AM1.CO_SEQ_ACOMPANHAMENTO) FROM DBOUVIDOR.TB_ACOMPANHAMENTO_MANIFESTACAO AM1 WHERE AM1.CO_MANIFESTACAO = M.CO_SEQ_MANIFESTACAO AND AM1.CO_SITUACAO_ACOMPANHAMENTO NOT IN (2,11,17))) |
Messages In This Thread |
oci_execute(): ORA-01799: a column may not be outer-joined to a subquery - by Jairo Gratao - 01-28-2020, 08:56 AM
RE: oci_execute(): ORA-01799: a column may not be outer-joined to a subquery - by php_rocs - 01-28-2020, 11:32 AM
RE: oci_execute(): ORA-01799: a column may not be outer-joined to a subquery - by Jairo Gratao - 01-31-2020, 04:35 AM
|