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:

Forms 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 ;
This entry was posted in Oracle forms. Bookmark the permalink.

5 Responses to Oracle Forms popup dialog alert box

  1. Claudio Hernrique says:

    vlw Demais!
    thank you! I need this dialog!!!
    chenpes!

  2. fayaz says:

    i am having one create item button if i click it item is created . but i need to get a pop up message whether it is success r any error in the procedure i should get a message when ever i run the form.

  3. raghu says:

    Hi
    You can mention message as message(‘Hello World’); in When_New_Form_Instance

  4. Frank says:

    Thank You!

  5. surendra says:

    Thanks…
    This post help me create the alert message.

    Regards,
    Surendra

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>