Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-02 |
|
|
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.
Note:
The USETRIGGERS option must be set to its default value ofTRUE
for a TRIGGER_AW program to executeSee also:
"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.
Syntax
To create a program with the name TRIGGER_AW
, follow the guidelines presented in"Trigger Programs".