Using Find_Alert and Show_Alert in Oracle Forms
Show_alert is used to display model window messages in Oracle Forms and Find_alert searches the list of valid alerts in Form Builder, when the given alert is located, the subprogram returns an alert ID. You must return the ID to an appropriately typed variable, define the variable with a type of Alert.
Example
Show a user-warning alert. If the user presses the OK button, then make REALLY sure they want to continue with another alert.
See also: Display Modal Window Messages Using Alerts
http://www.foxinfotech.in/2015/02/using-single-alert-for-messages-and-confirmation-messages.html
Declare
al_id alert;
al_button NUMBER;
BEGIN
al_id := FIND_ALERT ('user_warning');
IF ID_NULL (al_id)
THEN
MESSAGE ('user_warning alert does NOT exist');
RAISE form_trigger_failure;
ELSE
/*
** Show the warning alert
*/
al_button := SHOW_ALERT (al_id);
/*
If user pressed OK (button 1) then bring up another alert to confirm -- button mappings are specified in the alert design
*/
IF al_button = alert_button1
THEN
al_id := FIND_ALERT ('are_you_sure');
IF ID_NULL (al_id)
THEN
MESSAGE ('the alert NAMED:are you sure ? does NOT exist');
RAISE form_trigger_failure;
ELSE
al_button := SHOW_ALERT (al_id);
IF al_button = alert_button2
THEN
-- do some task
erase_all_employee_records;
END IF;
END IF;
END IF;
END IF;
END;
Follow to get notifications for tutorials with free source code, thanks.
Show_Alert and Find_Alert in Oracle Forms
Reviewed by Mridula Joshi on
Mar 22
Rating:
5
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步