ORA-01438 error while inserting a record.
Hi ,
Below is my table desc.
SQL> desc IEE_TEST
Name Null? Type
----------------------------------------------------- -------- ------------------------------------
OPERATING_COMPANY VARCHAR2(10)
METER_MULTIPLIER NUMBER(12,4)
PULSE_MULTIPLIER NUMBER(7,9)
ACCOUNTCODE_TYPEID VARCHAR2(10)
METER_TIMEZONE VARCHAR2(20)
RECORDINGDEVICE_TIMEZONE VARCHAR2(20)
CHANGESTODST
and when i try to insert a new record it get ORA error ORA-01438 sometime in strange way.
SQL> insert into IEE_TEST values('NSP_MN',300,.300300000,'BI','Central','US','Y');
insert into IEE_TEST values('NSP_MN',300,.300300000,'BI','Central','US','Y')
*
ERROR at line 1:
ORA-01438: value larger than specified precision allows for this column
SQL> insert into IEE_TEST values('NSP_MN',,300,.000300000,'BI','Central','US','Y');
1 row created.
Even in both precision digits are 9 but I noticed 1 thing, if 1 and 2 digit (i.e .300300000 or .030300000) greater than 0 then it throws error.
Please assist me in this.