teste

plsql 

CopyEdit 

IF :order_date < TRUNC(SYSDATE) THEN 

   MESSAGE('The order date cannot be in the past.'); 

   RAISE FORM_TRIGGER_FAILURE; 

END IF;