hi
In my Application page i have an item :p1_col1 (textbox), a validation item not null (:p1_col1) and a process(insert) i.e
begin
insert into tab (col1) values (:p1_col1);
end;
the col1 is not null field in backend and and..............and inside a table trigger (before insert, update) a statement is written i.e
IF inserting or updating THEN
:NEW.col1 :=UPPER(TRIM(:NEW.col1));
END IF;
now what my testing team doing is, they are just putting a space (by using spacebar) in the :p1_col1 field and pressing submit button. so what happen is, in that case "item not null" validation will not work (because item holding a value) and finally "constraint xxxx violated" error will occur in the main screen because the trigger is triming the data before insert.
So my question is, will they (htmldb group) provide some more attributes in "item not null" validation (like item not null suppress null values or trim data something like) in the newer version or will keep this thing same.
because now For me its time to convert all the "item not null" validations (more than 100) into sql or pl/sql validations.