No decimals returned from a Dataset query

Classic Servoy
1

I have two Globals defined as number:

number1
number2

I run the following method:

var select =
"select sum(total) from xxxxx"
var dataset = databaseManager.getDataSetByQuery(controller.getServerName(), select, null, 1);
dataset.rowIndex = 1;
globals.number1 = dataset[1];


var select2 =
"select to_char (sum(total),'FM999,999,999.99') from xxxxx"
var dataset2 = databaseManager.getDataSetByQuery(controller.getServerName(), select2, null, 1);
dataset2.rowIndex = 1;
globals.number2 = utils.stringToNumber(dataset2[1]);

The results are:

number1: 11 (No decimals !!!)
number2: 11.7

Servoy 2.1.1
Oracle 9i

2

What does the first select return if you do this query in a sql tool?
Do you see then the decimals?
What type does total have in the database?

3

What does the first select return if you do this query in a sql tool?

with sqlplus I get a a result: 11,7
The field is defined like this:

TOTAL NUMBER (20,6),
4

this is an oracle driver bug.
I made a workaround for 2.1.2.