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: