Skip Headers

Oracle® OLAP DML Reference
10g Release 1 (10.1)

Part Number B10339-02
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page

Go to previous page
Go to next page
View PDF


A TRIGGER_AW program is a program that you create and that Oracle OLAP checks for by name when an AW command executes. When the program exists in the same analytic workspace that you are updating, Oracle OLAP executes the program and then, depending on the value returned by the program (if any), either does nor does not update the workspace.


The USETRIGGERS option must be set to its default value of TRUE for a TRIGGER_AW program to execute

See also:

A TRIGGER_AW program is only one of a number of trigger programs that you can write. You can write other trigger programs as described in "Trigger Programs".

Return Value

You can write the program as a function that returns a BOOLEAN value. In this case, when the program returns FALSE, Oracle OLAP does not execute the UPDATE statement that triggered the execution of the TRIGGER_AW program; when the program returns TRUE or NA, the AW command executes.


No Support for Recursive Triggers

Oracle OLAP does not support recursive triggers. You must set the USETRIGGERS option to NO before you issue an AW command within a TRIGGER_AW program.


To create a program with the name TRIGGER_AW, follow the guidelines presented in"Trigger Programs".