ORA-01861 literal does not match format string

[raf]

hi,
when i try insert into table Area this values 5.4 I get always this error:

ORA-01861 literal does not match format string

datatype columns are number(10,2)

Could you help me??

Thanks

Raf

[Sameer]

Can't be.. Post complete sql statement and table description..

SQL> create table tab1 (id number(10,2));

Table created.

SQL> desc tab1
 Name                                      Null?    Type
 ----------------------------------------- -------- ------------------
 ID                                                 NUMBER(10,2)

SQL> insert into tab1 values (5.4);
SQL> insert into tab1 values (1234567.12);
SQL> insert into tab1 values (12345678.12);
1 row created.

SQL> select * from tab1;

        ID
----------
       5,4
1234567,12
12345678,1