Function Displaying an Alert that does not disappear
Hi. I have the following function:
FUNCTION show_yesno_alert (the_alert_message VARCHAR2)RETURN CHAR IS
o_response varchar2(3):= null;
alert_return_value number;
BEGIN
set_alert_property('al_yesno',alert_message_text,the_alert_message);
set_alert_property('al_yesno',title, 'Validation Read');
set_alert_button_property('al_yesno',alert_button1,label,'Yes');
set_alert_button_property('al_yesno',alert_button2,label,'No ');
set_alert_button_property('al_yesno',alert_button3,label,'Cancel');
alert_return_value := show_alert('al_yesno');
if alert_return_value = alert_button1 then
o_response:='YES';
elsif alert_return_value = alert_button2 then
FUNCTION show_yesno_alert (the_alert_message VARCHAR2)RETURN CHAR IS
o_response varchar2(3):= null;
alert_return_value number;
BEGIN
set_alert_property('al_yesno',alert_message_text,the_alert_message);
set_alert_property('al_yesno',title, 'Validation Read');
set_alert_button_property('al_yesno',alert_button1,label,'Yes');
set_alert_button_property('al_yesno',alert_button2,label,'No ');
set_alert_button_property('al_yesno',alert_button3,label,'Cancel');
alert_return_value := show_alert('al_yesno');
if alert_return_value = alert_button1 then
o_response:='YES';
elsif alert_return_value = alert_button2 then
0