ORA-01438 Error

Question

Can anyone help me with this exception?

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

ORA-06512: at "DM001.DFEE_AFT_IUD_JOURNAL", line 58

ORA-04088: error during execution of trigger 'DM001.DFEE_AFT_IUD_JOURNAL' ORA-06512: at line 4

What happened was the Primary Key was set up as a NUMBER(3) and when the value got to 999 the sequence started throwing this error. That is why it seemed to come out of no where when nothing had changed. — esastincy, Aug 17 '11 at 17:54

score 3 · Answer 1 · answered Aug 16 '11 at 17:16

3

You are trying to store a value into the field of a record that is longer than the column definition of the table allows.

Your column might be defined as NUMBER(3), but you're trying to store a longer number like 1250 into it.

answered Aug 16 '11 at 17:16

Codo

75,595
17
168
206

score 2 · Accepted Answer · answered Aug 16 '11 at 17:14

2

You are trying to insert a value in any column that has a "precision" larger than the defined.

answered Aug 16 '11 at 17:14

gandarez

2,609
4
34
47

score 1 · Answer 3 · answered Aug 16 '11 at 17:17

1

You've probably tried to enter a value greater than de defined when you created the table (i.e. varchar2(4) -> value tried 10000)

answered Aug 16 '11 at 17:17

lgtelles

41
3

ORA-01438 Error

3 Answers3