Error, invalid number Jasperstudio and Oracle 12c

Question

In the following SQL:

select cast(parvalor as float) valor from parametros where parid = 26

I want to get the data in decimal, use TO_NUMBER and CAST (XX AS FLOAT) but it does not work.

This query runs in ORACLE 12c and works normal, but when I execute it in JasperStudio 6.3, I get

error ORA-01722: invalid number.

I really have no idea where the error is, please help.

Answer 1

Ok, changing data decimal "," to ".", jasper recognized query, but in oracle no is functional, what is the problem?