I have the following table and try to insert a new row in data grid:
CREATE TABLE toad_test ( id NUMBER(1) NOT NULL, ts TIMESTAMP );
If I provide a ts but no id and confirm, I get this error as expected
ORA-01400: cannot insert NULL into ("X"."TOAD_TEST"."ID")
I can continue to edit that row.
If I enter an invalid date I get exceptions like these as expected
ORA-01858: a non-numeric character was found where a numeric was expected
ORA-01843: not a valid month
The new row vanishes though without a chance to fix the problems.