• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
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


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2021 MyBB Group.