passthru query rounding my return

[rockies1]

I have a passthru query to an oracle table that is supposed to return the sum of a field with a format of Number(11,2).

It holds currency values, but when I get the return, it is rounded ot the nearest dollar.

My SQL is:

SELECT 
  sum(charge_cr_amt) as TotalUsage
FROM 
  adhoc_view.charge_cr_item
WHERE 
  acct_nbr = '0061006071' and
  charge_cr_eff_dt between '20020207' and '20020319' and
  charge_type_cd in ('U','B')

Am I doing something wrong?

[This message has been edited by rockies1 (edited 03-28-2002).]