• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 5266
  • Last Modified:

ORA-01438: value larger than specified precision allows for this column

Hi, i got this error message when i try to save records.

Can anyone tell me y was that?

  • 3
1 Solution
You have a column in your table which has like NUMBER(5,2).
In this case only 3 digits are allowed before decimal points, if you try to insert more than three digits before decimal points you will get this error.

So, get table structure by DESC table_name.

then check the datatype for the column that has NUMBER(s,p) type. Means s-p digits before decimal and p digits after decimal are allowed. If you put more that p digits after decimal, you will not error , but values after  allowed precision will be rounded.

You should not put more than s-p digits before decimal points in your decimal points.

for ex.
SQL> create table test4(val number(5,2));

Table created.

SQL> insert into test4 values(1234.54);
insert into test4 values(1234.54)
ERROR at line 1:
ORA-01438: value larger than specified precision allows for this column

SQL> insert into test4 values(123.34);

1 row created.

saisai1022Author Commented:
Hi, thank you for answering my question.
However, i didn't set the datatype NUMBER to any decimal place. And the error message did occur to other canvas (form6i) as well when i'm trying to save the record.

My table is DRIVER:
licenceno VARCHAR(15),
staffno VARCHAR(6),
taxino VARCHAR(10).
Check for all tables and their structure that you access in form either as base table or as explicit insert statement.
Good to here that your problem get solved . Can i ask you,  why did you give Grade 'B' ?

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now