Oracle Forms popup dialog alert box

Howto create a popup dialog box in Oracle Forms – called ‘alerts’ although can be used for all kinds of purposes, not just alerting.

First create a new alert. Alerts are listed in the forms developer object navigator, immediately underneath Triggers. You can specify text and button names in the property palette of this new alert:

Then this new alert operates like a function, so you can call it in e.g. when-button-pressed triggers like this:

BEGIN
  -- Prompt user with a message dialog box, and only proceed with the delete if they click 'ok'
  IF show_alert('alert_confirm_delete') = alert_button1
  THEN
    DELETE FROM phototable WHERE id = :myblock.myid ;
  END IF ;
END ;