weird happening with Money field in view
Posted in 2005
We are having a weird situation with a money field that hopefully someone can shine a light on to why it's happening and how to fix or code around it. We have a proc that basically sums up a money field based on selection criteria passed into it. The proc does a simple select (nvl (sum amt), 0) on the field amt which is defined in the database as a money field. Using debug the amt for our test case sums to $335.21, which is correct if we hand total the records. However when the proc does the let return_var =, we get 335.2099999999999800 which is being interpreted by the view that calls the proc as $335.20 Its not happening on every person only a handful. Why are we getting these weird numbers. John David Adamski Network Specialist/DBA Graceland University