ORA-01401 has been discarded in Oracle 10g

A new error message ORA-12899 has been created instead of the dreaded ORA-01401 error message in Oracle 10g version.

What is the benefit of changing this error ?


Well while this new error message is displayed Oracle will also display the field name in which the NULL was not allowed.

"ORA-01401: Inserted value too large for column"

ORA-12899: value too large for column
"DB"."TABLE_NAME"."FIELD_NAME" (actual: 6, maximum:5)

This was a nice enhancement.

Ask Tom Article:
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::
P11_QUESTION_ID:7143933880166