This discussion is archived
5 Replies Latest reply: Dec 31, 2012 12:32 AM by Osama_Mustafa RSS

ORA-01438

Murali.Raju Newbie
Currently Being Moderated
Please help this issue.

SQL> create table t51(t5 NUMBER(25,8));

Table created.

SQL> insert into t51 values (100000000000000000.00000);
insert into t51 values (100000000000000000.00000)
*
ERROR at line 1:
ORA-01438: value larger than specified precision allowed for this column

Regards
Murali R
  • 1. Re: ORA-01438
    sb92075 Guru
    Currently Being Moderated
    Murali.Raju wrote:
    Please help this issue.

    SQL> create table t51(t5 NUMBER(25,8));

    Table created.

    SQL> insert into t51 values (100000000000000000.00000);
    insert into t51 values
    (100000000000000000.00000)
    0123456789012345678
    *
    ERROR at line 1:
    ORA-01438: value larger than specified precision allowed for this column

    Regards
    Murali R
    Connected to:
    Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options
    
    SQL> create table t51(t5 NUMBER(25,8));
    
    Table created.
    
    SQL> insert into t51 values (100000000000000000.00000);
    insert into t51 values (100000000000000000.00000)
                            *
    ERROR at line 1:
    ORA-01438: value larger than specified precision allowed for this column
    
    
    SQL> ed
    Wrote file afiedt.buf
    
      1* insert into t51 values (10000000000000000.00000)
    SQL> /
    
    1 row created.
    
    SQL> -- one digit too large
    SQL> 
    Handle:     Murali.Raju
    Status Level:     Newbie
    Registered:     Oct 12, 2009
    Total Posts:     10
    Total Questions:     7 (7 unresolved)

    why do you waste time here when you NEVER get your questions answered?
  • 2. Re: ORA-01438
    Murali.Raju Newbie
    Currently Being Moderated
    I need same value to insert.

    --

    we have already same value in other table.

    insert into rmurali.t51 select * from xxx;
    1 row created.

    but i have insert command show error.

    ---
  • 3. Re: ORA-01438
    sb92075 Guru
    Currently Being Moderated
    Murali.Raju wrote:
    I need same value to insert.

    --

    we have already same value in other table.

    insert into rmurali.t51 select * from xxx;
    1 row created.

    but i have insert command show error.

    ---
    either change the data or change the table; Oracle is to dumb to mis-report reality
    You don't have t convince me of anything.
    You need to have Oracle perform without throwing any error
  • 4. Re: ORA-01438
    SalmanQureshi Expert
    Currently Being Moderated
    Hi,
    Paste result of following query from both of the database. Paste your result in CODE tag please.
     select property_name,property_value from database_properties where property_name='NLS_LENGTH_SEMANTICS' or property_name='NLS_CHARACTERSET';
    See following

    http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1856720300346322149

    Salman
  • 5. Re: ORA-01438
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    Murali.Raju wrote:
    I need same value to insert.

    --

    we have already same value in other table.

    insert into rmurali.t51 select * from xxx;
    1 row created.

    but i have insert command show error.

    ---
    modify column in this case

    ALTER TABLE <TABLE_NAME> Modify ....

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points