Using User-Named Triggers in Oracle Forms

最新推荐文章于 2025-09-11 20:53:34 发布

转载最新推荐文章于 2025-09-11 20:53:34 发布 · 88 阅读

文章标签：

本文介绍了用户自定义触发器的概念及其在表单中的应用。用户自定义触发器由开发者定义，不会自动响应表单构建事件，必须从其他触发器或用户自定义子程序中显式调用。通过EXECUTE_TRIGGER内置过程执行，并可在菜单PL/SQL命令中调用执行用户自定义子程序。

A user-named trigger is a trigger defined in a form by the developer. User-Named triggers do not automatically fire in response to a Form Builder event, and must be called explicitly from other triggers or user-named subprograms. Each user-named trigger defined at the same definition level must have a unique name.
To execute a user-named trigger, you must call the EXECUTE_TRIGGER built-in procedure, as shown here:

Execute_trigger(’my_user_named_trigger’);

Usage Notes:
User-named PL/SQL subprograms can be written to perform almost any task for which one might use a user-named trigger.
As with all triggers, the scope of a user-named trigger is the definition level and below. When more than one user-named trigger has the same name, the trigger defined at the lowest level has precedence.
It is most practical to define user-named triggers at the form level.
Create a user-named trigger to execute user-named subprograms defined in a form document from menu PL/SQL commands and user-named subprograms. (User-named subprograms defined in a form cannot be called directly from menu PL/SQL, which is defined in a different document.) In the menu PL/SQL, call the EXECUTE_TRIGGER built-in to execute a user-named trigger, which in turn calls the usernamed subprogram defined in the current form.