When retrieving a field defined as NUMBER(10) in Oracle database into a variable defined as Integer I get the following conversion error message
Java.lang.ClassCastException: java.math.BigDecimal cannot be cast to java.lang.Integer
The same happens if the variable is defined as long or double and in the BDM.
e.g. when having it as double, the error is "java.math.BigDecimal cannot be cast to java.lang.Double"