Using user-named Triggers in Oracle Forms

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.