Exception and Error Handling Enhancements In Oracle9i Code:
CREATE TABLE TEST(TEST_ID INTEGER PRIMARY KEY,TEST_DESC VARCHAR2(5));
INSERT INTO TEST VALUES ( 1,'May be this time is the correct one !' );
Output Error Message: Code:
ORA-01401: inserted value too large for column.
In Oracle-10g Code:
CREATE TABLE TEST(TEST_ID INTEGER PRIMARY KEY,TEST_DESC VARCHAR2(5));
INSERT INTO TEST VALUES ( 1,'May be this time is the correct one !' );
Output Error Message: Code:
ORA-12899: value too large for column "TEST"."TEST"."TEST_DESC" (actual: 37, maximum: 5).
And still many more......