USETRIGGERS

The USETRIGGERS option determines if a trigger program as triggers execute.

Tip:

Oracle OLAP does not support recursive triggers. Set the USETRIGGERS option to NO before you issue the same DML statement within a trigger program that triggered the program itself. For example, assume that you have written a TRIGGER_DEFINE program. Within the TRIGGER_DEFINE program, you must set the USETRIGGERS option to NO before you issue a DEFINE statement

See also:

"Trigger Programs"

Data Type

BOOLEAN

Syntax

USETRIGGERS = {NO|YES}

Parameters

YES: (Default) Trigger programs execute.
NO: Trigger programs do not execute.

Examples

Example 5-110 Changing USETRIGGERS to NO

Assume you have just created a new analytic workspace. As illustrated in the following statement, the default value of the USETRIGGERS option is YES, but you can set the option to NO at any time.

SHOW USETRIGGERS
yes
 

USETRIGGERS = NO
SHOW USETRIGGERS
no