Code:
drop trigger date_validation;
create or replace trigger date_validation
before insert or update on PROJECT for each row

BEGIN
  IF (:NEW.pro_startdate > :NEW.pro_enddate) THEN
    raise_application_error(-20000, 'ERROR!!start date for the project must be insert first before inserting end date');
  END IF;
END;