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"This was a nice enhancement.
ORA-12899: value too large for column
"DB"."TABLE_NAME"."FIELD_NAME" (actual: 6, maximum:5)
Ask Tom Article: