Follow-On Topics

Related Topics

# Adding an Oracle Trigger Task Step

The Oracle Trigger step triggers a task to run when a specific table in an Oracle database is updated, deleted, or has a new row inserted.

In addition, global variables created for the task can be mapped to a specific column in the selected table, so that the column value may be used in other steps.

To add a new Oracle Trigger step to an existing task, do the following:

1. Open the relevant task (for creating new tasks, see Creating a New Task).
2. Either:

|  | Click and drag the Oracle Trigger icon from the Task Browser to the task Design area.

|  | Click on the Environment tab in the Task Browser. Right-click on Steps and select New > Event > Oracle Trigger.

|  | From the task's Design tab, right-click on empty space and select New > Event > Oracle Trigger.

3. Enter a Name and Description for the step.
4. Select the Main tab, and then select a server from the drop down list. Note that the Oracle Trigger Agent must be installed on the target Oracle Server machine for it to be exposed in the drop down list.
5. Enter the credentials necessary to access the selected server, or select the Use Trusted Connection option.
6. Click Browse to open the Oracle Browser dialog box. Select a database and table or view and click OK to close the dialog box.
7. Select a Trigger Order option, and then select the Trigger tab.
8. Select the Configure tab, and then complete all configuration. If you are running multiple tasks for each row in a result set, columns may be mapped to task variables, which are automatically exposed in the Map Columns to Task Parameters table.
9. Alternatively, select the Script tab and then click on the Edit button to create the Oracle script for the trigger.
10. Click OK to save the new step and close the dialog box. An icon for the step is displayed on the Task Plan.
11. Click and drag the Oracle Trigger icon onto the first step in the task.
12. Click OK to save the changes and close the Task dialog box.

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