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

Posted on 2003-03-15
Medium Priority
Last Modified: 2012-06-27
Hi, i got this error message when i try to save records.

Can anyone tell me y was that?

Question by:saisai1022
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3

Expert Comment

ID: 8145004
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.


Author Comment

ID: 8145586
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).

Accepted Solution

allahabad earned 60 total points
ID: 8145618
Check for all tables and their structure that you access in form either as base table or as explicit insert statement.

Expert Comment

ID: 8180860
Good to here that your problem get solved . Can i ask you,  why did you give Grade 'B' ?

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Suggested Courses

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question