This discussion is archived
10 Replies Latest reply: Jan 15, 2013 10:01 AM by 982158 RSS

verification an item manually

982158 Newbie
Currently Being Moderated
I want to check an item manually.
Here is the code:

     i number;

if :a.b is null then
else if :a.b between 1900 and 2013 then
     message('date valid');
     raise form_trigger_failure;     

end if;
end if;

exception when others then

the problem for example when I entered a value "3000" I received two messages (the first on the alert "date_invalid" and the 2nd on the exception message)
but normally I must received one message, the relative "date_invalid"


  • Correct Answers - 10 points
  • Helpful Answers - 5 points