Tuesday, January 21, 2020

Oracle forms Create Alert

DECLARE
  Alert_ID        ALERT;
  n_alert_button  NUMBER;
BEGIN
  Alert_ID := Find_Alert('NOTE');
  Set_Alert_Property(Alert_ID, TITLE, 'Title of the Information here.');
  Set_Alert_Property(Alert_ID,ALERT_MESSAGE_TEXT, 'Enter date in format: MM/DD/YYYY');
  n_alert_button := Show_Alert(Alert_ID);
END;