I have an SQL Query that displays rounded success percentages. It is just a regular number row that includes number values.
Query is shown below:
SELECT QUANTITY_SUCCESS FROM GOALS
WHERE OWNER = 'M.TURHAN'
AND MONTH = TO_CHAR(SYSDATE, 'MM/YYYY')
Table structure is shown below:
When I execute this on SQL Commands, all I see is;
But when I use the same query on Page Designer to create a chart, I get ORA-01722 error.
Which means: “ORA-01722: String value containing '.' cannot be converted to a number:”
I am trying to fix this for a day, I tried to_number, to_char but nothing seems to fix it.
Once, I changed the application language to Turkish and immediately switch back to English (en), but I still get the error in Turkish, I just wanted to let you know.
Any help would be appreciated.
Thanks all in advance!