Welcome Guest, Not a member yet? Register   Sign In
oci_execute(): ORA-01799: a column may not be outer-joined to a subquery
#1

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)))
Reply
#2

@Jairo Gratao,

Do you build this query or are you using query binding?
Reply
#3

solved. the problem was wamp cache. I restarted and the problem was fixed. thanks.
Reply




Theme © iAndrew 2016 - Forum software by © MyBB