Using Post-Form Trigger In Oracle Forms

发布时间:2017-2-27 3:26:27 编辑 分享查询网我要评论
本篇文章主要介绍了"Using Post-Form Trigger In Oracle Forms ",主要涉及到Using Post-Form Trigger In Oracle Forms 方面的内容,对于Using Post-Form Trigger In Oracle Forms 感兴趣的同学可以参考一下。

Using Post-Form Trigger In Oracle Forms

Post-Form trigger in Oracle Forms fires during the Leave the Form process, when a form is exited.
You can use Post-Form trigger for the tasks such as: To clean up the form before exiting. For example, use a Post-Form trigger to erase any global variables that the form no longer requires. To display a message to the operator upon form exit etc.
This trigger does not fire when the form is exited abnormally, for example, if validation fails in the form and on failure processing halts.
Create the post-form trigger as shown in below screen shot:
Below is the example given for post-form trigger to ask the user on exit of the form that "Are you sure to Exit?" if user choose yes (alert_button1) then exit and if user choose No (alert_button2) then cancel the exiting of form.
if show_alert('conf_alert') = alert_button1 then
  -- do nothing or perform any task on exiting such as log some data etc.   
          -- and form will exit.
raise form_trigger_failure;
        -- this will cancel the forms exit execution.
end if;

上一篇:Openfire 4.1.0