Learn how to use single Oracle Form‘s Alert object for warning/information messages and confirmation messages such as asking for delete confirmation etc. This task can be done using Set_Alert_Button_Property command.

Suppose you have created an alert with single button or with two button but for warning messages an alert should have single button and for confirmation messages an alert should have two buttons asking for "Yes/No" or "OK/Cancle", below is the example given to manage single alert for both type messages:

Create an Alert in Oracle Forms object navigator and write the following code for giving simple  or warning messages:

declare

 n number;

begin

 set_alert_button_property(‘alert‘, alert_button2, label, ‘‘);

 set_alert_property(‘alert‘, alert_message_text, ‘Message Alert!‘);

  n := show_alert(‘alert‘);

end;

In the above example we are setting alert_button2 (second alert button) property to null means it will not show the second button in alert window.

Following is the example to use same alert for asking for confirmation by setting second alert button property to some value:

declare

 n number;

begin

 set_alert_button_property(‘alert‘, alert_button1, label, ‘Yes‘);

 set_alert_button_property(‘alert‘, alert_button2, label, ‘No‘);

 set_alert_property(‘alert‘, alert_message_text, ‘Do you know Oracle?‘);

  n := show_alert(‘alert‘);

  if n = alert_button1 then

     :buttonsel := ‘You choose YES!‘;

  else

           :buttonsel := ‘You choose NO!‘;

  end if;

end;

You can download this demo form from the following link dynalert.fmb

Screen shot of this form is below

See also: http://www.foxinfotech.in/2013/03/findalert-showalert-oracle-forms.html

Using Single Alert For Messages And Confirmation Messages In Oracle Forms With Set_Alert_Button_Property