Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from Oracle in a Nutshell

Call

PROCEDURE DBMS_RULE.EVALUATE (rule_set_name IN VARCHAR2, evaluation_context IN VARCHAR2, event_context IN SYS.RE$NVLIST DEFAULT NULL, table_values IN SYS.RE$TABLE_VALUE_LIST DEFAULT NULL, [column_values IN SYS.RE$COLUMN_VALUE_LIST,] variable_values IN SYS.RE$VARIABLE_VALUE_LIST DEFAULT NULL, [attribute_values IN SYS.RE$ATTRIBUTE_VALUE_LIST,] stop_on_first_hit IN BOOLEAN DEFAULT FALSE, simple_rules_only IN BOOLEAN DEFAULT FALSE, true_rules OUT SYS.RE$RULE_HIT_LIST, maybe_rules OUT 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.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page