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 ;