5 Replies Latest reply: Dec 31, 2012 2:32 AM by Osama_Mustafa RSS

    ORA-01438

    Murali.Raju
      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
          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
            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
              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
                Salman Qureshi
                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
                  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 ....