Oracle Connector - BigDecimal Problem

Hi,

I have a problem with the Oracle Connector. What data type should I use to be able to save the value in a SQL query BigDecimal?

Select amount from customers where customer_id=1 When testing the connectors the correct value comes out in the format BigDecimal, later in the process, the process stops then...

nobody any suggestion? BigDecimal to Integer?