![]() Previous |
![]() Next |
A TRIGGER_AW program is a program that you can create in one analytic workspace and that Oracle OLAP checks for by name when that analytic workspace is current and you create, attach, detach, or delete any other analytic workspace.
Note: Oracle OLAP checks for this program and other programs when a user attaches an analytic workspace. See "Startup Programs" for more information. |
Return Value
None.
Syntax
To create a program with the name TRIGGER_AW
, follow the guidelines presented in"How to Create a TRIGGER_AW Program".
Usage Notes
How to Create a TRIGGER_AW Program
You create a TRIGGER_AW program by following the following procedure:
Define the program as described in DEFINE PROGRAM.
Name the program TRIGGER_AW.
Code the actual program as described in"Specifying Program Contents".
Note: There is no support for recursive triggers. You must set the USETRIGGERS option toNO before you issue an AW statement within an TRIGGER_AW program |
Examples
A TRIGGER_AW Program
Assume that you have defined a program with the following definition in an analytic workspace named my_aw
.
DEFINE TRIGGER_AW PROGRAM PROGRAM SHOW CALLTYPE SHOW TRIGGER(EVENT) SHOW TRIGGER(SUBEVENT) SHOW TRIGGER(NAME) END
When attach the my_aw
workspace, the specified values are displayed.
AW ATTACH MY_AW TRIGGER AW ATTACH MY_AW