Guys,
Im trying to execute one select command from Oracle in jdbc adapter sender, but the one return full result (no filter by where)
Example:
SELECT * FROM FATURAMENTO_RECARGA WHERE CONTROLE = 'P' AND CD_CORTE BETWEEN (SELECT MIN(CD_CORTE) FROM FATURAMENTO_RECARGA WHERE CONTROLE = 'P') AND (SELECT MIN(CD_CORTE) +150 FROM FATURAMENTO_RECARGA WHERE CONTROLE = 'P') order by cd_nota_debito
The sql command execute SELECT * FROM FATURAMENTO_RECARGA WHERE CONTROLE = 'P', but dont filter the others parammeters (AND CD_CORTE BETWEEN (SELECT MIN(CD_CORTE) FROM FATURAMENTO_RECARGA WHERE CONTROLE = 'P') AND (SELECT MIN(CD_CORTE) +150 FROM FATURAMENTO_RECARGA WHERE CONTROLE = 'P') )
Can anybody help me? Please.