Oracle | DBMS

Oracle DBMS_RULE Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose This package contains subprograms that support the evaluation of rule sets

AUTHID CURRENT_USER

Dependencies

DBMS_AQ_INV	RE$COLUMN_VALUE_LIST	RE$TABLE_ALIAS_LIST
DBMS_RULES_LIB	RE$NV_LIST	RE$TABLE_VALUE_LIST
DBMS_RULE_INTERNAL	RE$RULE_HIT	RE$VARIABLE_TYPE_LIST
RE$ATTRIBUTE_VALUE_LIST	RE$RULE_HIT_LIST	RE$VARIABLE_VALUE_LIST

Documented Yes

Exceptions

Error Code	Reason
ORA-25453	Invalid Iterator

First Available Not Known

Pragmas PRAGMA SUPPLEMENTAL_LOG_DATA(default, READ_ONLY);

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/rdbms/admin/dbmsread.sql

Subprograms

ANALYZE_EXPRESSION	EVALUATE	GET_NEXT_HIT
CLOSE_ITERATOR	EVALUATE_EXPRESSION	IS_FAST

ANALYZE_EXPRESSION (new 23ai)

Undocumented dbms_rule.analyze_expression( expression IN VARCHAR2, table_aliases IN sys.re$table_alias_list, variable_types IN sys.re$variable_type_list, sql_execution OUT BOOLEAN, dnf_count OUT BINARY_INTEGER, sqlopt_count OUT BINARY_INTEGER, exp_cost OUT BINARY_INTEGER);

TBD

CLOSE_ITERATOR

Closes an open iterator dbms_rule.close_iterator(iterator IN BINARY_INTEGER);

exec dbms_rule.close_iterator(1);

      

      PL/SQL procedure successfully completed.

EVALUATE

Evaluates the rules in the specified rule set that use the evaluation context specified

Overload 1 dbms_rule.evaluate( rule_set_name IN VARCHAR2, evaluation_context IN VARCHAR2, event_context IN sys.re$nv_list := NULL, table_values IN sys.re$table_value_list := NULL, column_values IN sys.re$column_value_list := NULL, variable_values IN sys.re$variable_value_list := NULL, attribute_values IN sys.re$attribute_value_list := NULL, stop_on_first_hit IN BOOLEAN := FALSE, simple_rules_only IN BOOLEAN := FALSE, result_cache IN BOOLEAN := TRUE, true_rules OUT sys.re$rule_hit_list, maybe_rules OUT sys.re$rule_hit_list);

TBD

Overload 2 dbms_rule.evaluate( rule_set_name IN VARCHAR2, evaluation_context IN VARCHAR2, event_context IN sys.re$nv_list := NULL, table_values IN sys.re$table_value_list := NULL, column_values IN sys.re$column_value_list := NULL, variable_values IN sys.re$variable_value_list := NULL, attribute_values IN sys.re$attribute_value_list := NULL, simple_rules_only IN BOOLEAN := FALSE, true_rules_iterator OUT BINARY_INTEGER, maybe_rules_iterator OUT BINARY_INTEGER);

TBD

EVALUATE_EXPRESSION

Evaluates an expression under the logged in user in a session dbms_rule.evaluate_expression( rule_expression IN VARCHAR2, table_aliases IN sys.re$table_alias_list := NULL, variable_types IN sys.re$variable_type_list := NULL, table_values IN sys.re$table_value_list := NULL, column_values IN sys.re$column_value_list := NULL, variable_values IN sys.re$variable_value_list := NULL, attribute_values IN sys.re$attribute_value_list := NULL, cache IN BOOLEAN := FALSE, result_val OUT BOOLEAN);

TBD

GET_NEXT_HIT

Returns the next rule that evaluated to TRUE from a true rules iterator, or returns the next rule that evaluated to MAYBE from a maybe rules iterator dbms_rule.get_next_hit(iterator IN BINARY_INTEGER) RETURN sys.re$rule_hit;

SELECT dbms_rule.get_next_hit(1);

             *

      ORA-25453: invalid iterator: 1

IS_FAST

Returns TRUE if the expression can be evaluated quickly dbms_rule.is_fast( expression IN VARCHAR2, table_aliases IN sys.re$table_alias_list := NULL, variable_types IN sys.re$variable_type_list := NULL, result_val OUT BOOLEAN);

TBD