Invalid Number error
690818May 22 2009 — edited May 22 2009Hello,
I have an sql-query for an SQL Report 'select to_number(PARAMETERWAARDE) from TBL_PARAMETERS where PARAMETERNAAM = 'CO² formule Diesel')'. When i run the page I get an error
report error:
ORA-01722: invalid number
The value that I retrieve from my database is 126,46/114,08. This is a varchar field. But in my report I want to see the value that is calculated. I have tried changing the ',' to a '.' but this is also to no avail. I thought that SQL would calculate this. Does anyone have any idea what could be wrong?
Can SQL calculate fractions, multiplications with the to_number function?
Thanks in advance,
Bram.