December 2002
Intermediate to advanced
928 pages
85h 29m
English
PROCEDURE DBMS_RULE_ADMIN.ADD_RULE
(rule_name IN VARCHAR2,
rule_set_name IN VARCHAR2,
evaluation_context IN VARCHAR2 DEFAULT NULL,
rule_comment IN VARCHAR2 DEFAULT NULL);
Adds rule_name to rule_set_name, with optional evaluation_context and rule_comment.
PROCEDURE DBMS_RULE_ADMIN.ALTER_RULE
(rule_name IN VARCHAR2,
condition IN VARCHAR2 DEFAULT NULL,
evaluation_context IN VARCHAR2 DEFAULT NULL,
remove_evaluation_context IN BOOLEAN DEFAULT FALSE,
action_context IN SYS.RE$NV_LIST DEFAULT NULL,
remove_action_context IN BOOLEAN DEFAULT FALSE,
rule_comment IN VARCHAR2 DEFAULT NULL,
remove_rule_comment IN BOOLEAN DEFAULT FALSE);
Alters rule_name by changing condition and either changing or removing the evaluation context, action context, or rule.
PROCEDURE DBMS_RULE_ADMIN.CREATE_EVALUATION_CONTEXT
(evaluation_context_name IN VARCHAR2,
table_aliases IN SYS.RE$TABLE_ALIAS_LIST DEFAULT NULL,
variable_types IN SYS.RE$VARIABLE_TYPE_LIST DEFAULT NULL,
evaluation_function IN VARCHAR2 DEFAULT NULL,
evaluation_context_comment IN VARCHAR2 DEFAULT NULL);
Creates evaluation_context_name with table aliases and variables specified in tables. evaluation_function is an optional function that will be used to evaluate rules using this context and which has the same form as the DBMS_RULE.EVALUATE procedure.
PROCEDURE DBMS_RULE_ADMIN.CREATE_RULE
(rule_name IN VARCHAR2,
condition IN VARCHAR2 DEFAULT NULL,
evaluation_context IN VARCHAR2 DEFAULT NULL,
action_context IN SYS.RE$NV_LIST DEFAULT NULL,