>
> sqlstring = 'select m.DESCRIPTION, t.CODE, c.CODE, sum(id.QTY), sum

(id.AMOUNT) '

> || 'from INVOICE i ' ||
> 'inner join INVOICE_DETAIL id on id.INVOICE_ID =
>i.ID
>into :DESCRIPTION, :TARIFF_CODE, :COUNTRY_CODE, :QTY, :INVOICE_AMOUNT

Try casting: CAST(sum(id.Qty) as Integer), Cast(sum(id.Amount) as
integer).

Maybe these fields are getting converted into another type when they
summed.

Rick