1 / 9

Introduction to Triggers

This lesson provides an overview of triggers and their categories. Learn how to plan and define triggers in a form, and understand the properties that impact trigger behavior. Explore trigger types and scope, including form, block, and item levels.

tomlinsonm
Download Presentation

Introduction to Triggers

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Introduction to Triggers

  2. Objectives After completing this lesson, you should be able to do the following: • Define triggers • Identify the different trigger categories • Plan the type and scope of triggers in a form • Describe the properties that affect the behavior of a trigger

  3. Form Builder Triggers PL/SQL Queries Validation Navigation Interaction Internal event Errors/Messages Others Event Fire PL/SQL PL/SQL Trigger types

  4. Trigger Scope Component Levels • Form • Block • Item Type Scope Code

  5. Event Event Event Trigger Scope

  6. Trigger Type Component • Pre- • Post- • When- • On- • Key- Type Scope Code

  7. Trigger Code Component • Statements • PL/SQL • User subprograms • Built-in subprograms Type Scope Code

  8. 4 Event Event Execution Hierarchy Formlevel On-Message On-Error 1 EH = Before Blocklevel On-Message On-Error 2 EH = After EH = Override On-Message Itemlevel 3 EH = After

  9. Summary • Trigger: Event-activated program units • Type: Defines the event that fires it • Prefixes: • Key- • On- • Pre- • Post- • When- • Code: PL/SQL anonymous block • Scope: Form, block, or item level

More Related