Call
-
PROCEDURE DBMS_RULE.EVALUATE(rule_set_nameIN VARCHAR2,evaluation_contextIN VARCHAR2,event_contextIN SYS.RE$NVLIST DEFAULT NULL,table_valuesIN SYS.RE$TABLE_VALUE_LIST DEFAULT NULL,[column_valuesIN SYS.RE$COLUMN_VALUE_LIST,]variable_valuesIN SYS.RE$VARIABLE_VALUE_LIST DEFAULT NULL,[attribute_valuesIN SYS.RE$ATTRIBUTE_VALUE_LIST,]stop_on_first_hitIN BOOLEAN DEFAULT FALSE,simple_rules_onlyIN BOOLEAN DEFAULT FALSE,true_rulesOUT SYS.RE$RULE_HIT_LIST,maybe_rulesOUT SYS.RE$RULE_HIT_LIST); Evaluates rule_set_name using evaluation_context and event_context (a list of name/value pairs that identify events that cause evaluation). The different values come from the specified tables. stop_on_first_hit causes the engine to stop when it hits the first rule that evaluates as TRUE or, in the absence of a TRUE rule, on one that may evaluate as TRUE if more data were present. If simple_rules_only, the procedure evaluates rules simple enough to be evaluated without issuing SQL statements. true_rules returns the rules that evaluate to TRUE based on the specified data. maybe_rules returns rules that could not be evaluated due to lack of data or the complexity of the rule, with simple_rules_only. column_values and attribute_values are either both present or both absent from this call.