title: A numeric field from an Oracle query return variable results when zero
body: <p>I have this odd behavior on a vb.net application, I make a simple query to an Oracle database using ODP.Net. One of the fields is a simple division but as expected, the result has many decimal values so I apply Oracle's Round function to it in order to bring up to 7 decimal values. </p>
  
  <p>Due the rounding, some very small values actually become zero which is fine, however, in some rows I get the zero value as expected but in another rows the same field shows with a null value instead of zero. </p>
  
  <p>I have dig both vb.net and odp.net but couldn't find an explanation for this. I have tested the query in both Toad and Oracle own SQL Developer, in all the result shows zeroes without issue, but still have the problem in vb.net.</p>
  
  <p>If anyone has any input to this, it will be really appreciated, thank you.</p>
  
  <p>J.</p>