[firebase-br] erro sp

[Francisco A Souza]

pessoal, na procedure abaixo, quando o retorno e nulo na tabela bairec ele 
da erro de conversao, se tiver dados ele roda legal.
alguem poderia dar uma dica?

FOR SELECT
   DUPREC.ID,
   DUPREC.DUPLICATA,
   DUPREC.PARCELA,
   DUPREC.EMISSAO,
   DUPREC.CLIENTE,
   DUPREC.VENCIMENTO,
   DUPREC.VALOR,
   DUPREC.BANCO,
   DUPREC.STATUS,
   DUPREC.SITUACAO,
   PESSOAS.NOME,
   BAIREC.BAIXA,
   coalesce(SUM( BAIREC.VALOR ),0,1) AS PAGO,
   SUM( BAIREC.JUROS ) AS JUROS,
   SUM( BAIREC.MULTA ) AS MULTA,
   SUM( BAIREC.DESCONTOS ) AS DESCONTOS
   FROM DUPREC
   LEFT OUTER JOIN BAIREC ON (DUPREC.ID = BAIREC.INTLAN)
   LEFT OUTER JOIN PESSOAS ON (DUPREC.CLIENTE = PESSOAS.ID)
   WHERE DUPREC.cliente=:ppess
   GROUP BY DUPREC.ID, DUPREC.DUPLICATA, DUPREC.PARCELA, DUPREC.EMISSAO, 
DUPREC.CLIENTE, DUPREC.VENCIMENTO, DUPREC.VALOR, DUPREC.BANCO, 
DUPREC.STATUS, DUPREC.SITUACAO, PESSOAS.NOME, BAIREC.BAIXA
   ORDER BY DUPREC.VENCIMENTO
   INTO :RID,
        :RDUP,
        :RPAR,
        :REMI,
        :RPES,
        :RVEN,
        :RVAL,
        :RBAN,
        :RSTA,
        :RSIT,
        :RNOM,
        :RBAI,
        :RPAG,
        :RJUR,
        :RMUL,
        :RDES

      DO

        SUSPEND;