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