Retrieve decimal value having more than 7 digits after decimal places (from third party database)

Hi All,

In third party database, we have a column (number datatype containing decimal values - NUMBER(15,12)) which can have more than 7 digits after decimal place. In database, for example, the value is 33.3333333333

but when we are fetching the data via query entity, it is coming as 33.33333 and not the entire value. Datatype we have used in CDT is Number (Decimal) and xsd type xsd:decimal. We have also tried xsd:double in CDT but the result is same.

Is there any range restriction on Number(Decimal) ?

How to fetch the entire value from database?

Kindly advice.


Thanks and Regards,

Diksha

  Discussion posts and replies are publicly visible