CODEWITHSUNDEEP
oracle-databaseplsqlora-06512ora-01438
esastincy
esastincy

Reputation: 1627

ORA-01438 Error

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

Upvotes: -3

Views: 3307

Answers (3)

lgtelles
lgtelles

Reputation: 41

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

Upvotes: 1

Codo
Codo

Reputation: 78855

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.

Upvotes: 3

gandarez
gandarez

Reputation: 2662

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

Upvotes: 2

Related Questions