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 is called explicitly from othe R triggers or user-named subprograms. Each user-named trigger defined at the same definition level must has 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 in which one might use a user-named trigger.< /c0>
as with all triggers, the scope of a user-named trigger are the definition level and below. When more than one user-named trigger have the same name, the trigger defined at the lowest level have 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 F ROM menu PL/SQL commands and User-named subprograms. (user-named subprograms defined in a form cannot being called directly from menu PL/SQL, which is defined in a different docu ment.) In the menu PL/SQL, call the Execute_trigger built-in to EXECUTE a user-named TRIGGER, which in turn calls the usernamed s Ubprogram defined in the current form.
Using user-named Triggers in Oracle Forms