Cannot insert quoted floating point numeric that contains a period.
Posted on 2004-10-21
I´m refactoring a legacy app in PHP.
The existing code quotes all fields while cunstructing the SQL command.
Whew I attempt to insert arecord as follows:
INSERT into Table VALUES ('10,5');
and the column is declared as a NUMERIC (10,2) for instance, evrything works fine.
but if I attempt to insert arecord as follows:
INSERT into Table VALUES ('10.5');
returns an ORA-01722: invalid number.
Changing NLS_NUMERIC_CHARACTERS has not solved the problem.