+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: General Help (https://forum.codeigniter.com/forumdisplay.php?fid=24)
+--- Thread: oci_execute(): ORA-01799: a column may not be outer-joined to a subquery (/showthread.php?tid=75343)
oci_execute(): ORA-01799: a column may not be outer-joined to a subquery - Jairo Gratao - 01-28-2020
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)))
RE: oci_execute(): ORA-01799: a column may not be outer-joined to a subquery - php_rocs - 01-28-2020
@Jairo Gratao,
Do you build this query or are you using query binding?
RE: oci_execute(): ORA-01799: a column may not be outer-joined to a subquery - Jairo Gratao - 01-31-2020
solved. the problem was wamp cache. I restarted and the problem was fixed. thanks.