Follow-On Topics

Related Topics

# About the Trigger Tab

You configure the Oracle events that trigger this step:

About the Configure Tab

The Configure tab provides configuration options to enable King Task Centre to automatically create the necessary Oracle script for the trigger. The script created may be viewed by clicking on the Script tab. The Configure tab contains the following:
|  | Trigger Type — The following options are provided for selection:
|  | UPDATE — When this trigger type is selected, the trigger is fired when a column in the selected table is updated.
|  | INSERT — When this trigger type is selected, the trigger is fired when a new row is added to the table.
|  | DELETE — When this trigger type is selected, the trigger is fired when an existing row is deleted from the table.
|  | Fire Type — The following options are provided for selection:
|  | BEFORE — When this trigger option is selected, the trigger fires before the table has been updated.
| Click the image to view full size.

|  | AFTER — This is the default trigger option which fires the trigger after the table has been updated.

|  | Run Task once for each Trigger — If this option is selected then the Task is run once for each trigger created for the Task. Numerous updates may therefore be made to the table but the trigger only fires once. No mapping of results set columns to Task Parameters is available, but any changes to the database that caused the trigger to fire may be accessed through King Task Centre's memory feature.

|  | Run Task once for each Row in Results Set — If this option is selected then the Task is run once for each row in the results set.

|  | Map Columns to Task Parameters — Displays a list of variables created for the Task. The Columns column contains a drop down list of columns for selection, from the Inserted and Deleted tables created by the Oracle Trigger, to be mapped against the variable. The variable may then be used to expose the selected column value to subsequent Steps.

|  | Only Fire Trigger when a selected Column is updated — Selecting this option activates the Columns table displayed below it.

|  | Columns — Displays a list of columns available in the selected database table. A check box is provided to the left of each column name. The trigger is then fired when any of the selected columns is updated.

|  | Filter Table — Selecting this option activates the Filter button so that it may be selected.

|  | Filter — Clicking on the Filter button opens the Selecting the Filter Table Expression dialog box box to enable a new expression to be entered.

About the Script Tab

|  | The Script tab is provided to enable the Oracle Script for a trigger to be manually created
|  | When the tab is first selected it displays the Oracle Script automatically created for the trigger through the Configure tab using the default options selected in the tab
|  | Selecting the Edit button switches the tab to script mode so that the Oracle Script may be manually edited
|  | Once the script mode has been selected it cannot be reversed and the trigger may only be edited by updating the Oracle Script
| Click the image to view full size.

Copyright © 2018 Quadrant Software B.V. All rights reserved.