Oracle and decimal

Posts   
 
    
buckd32
User
Posts: 20
Joined: 09-Oct-2009
# Posted on: 01-Mar-2010 17:29:39   

I have a number coulmn in oracle database with a size of lenght of 22 and a precision of 38 hence it should be able to store 12.48 but when i save it using conver.todecmal it stores it rounded so it does

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 02-Mar-2010 04:18:17   

You should specify the exact precision/scale. With a scale of 0, rounding occurs. Please show the snippet you are using to convert.

David Elizondo | LLBLGen Support Team