DBA Data[Home] [Help]

PACKAGE: SYS.DBMS_RULE

Source


1 PACKAGE dbms_rule AUTHID CURRENT_USER AS
2 
3  --------------------
4  -- PUBLIC CONSTANTS
5  --------------------
6 
7  ---------------------
8  -- PUBLIC PROCEDURE
9  ---------------------
10 
11   PROCEDURE evaluate(
12         rule_set_name           IN      varchar2,
13         evaluation_context      IN      varchar2,
14         event_context           IN      sys.re$nv_list := NULL,
15         table_values            IN      sys.re$table_value_list := NULL,
16         column_values           IN      sys.re$column_value_list := NULL,
17         variable_values         IN      sys.re$variable_value_list := NULL,
18         attribute_values        IN      sys.re$attribute_value_list := NULL,
19         stop_on_first_hit       IN      boolean := FALSE,
20         simple_rules_only       IN      boolean := FALSE,
21         result_cache            IN      boolean := TRUE,
22         true_rules              OUT     sys.re$rule_hit_list,
23         maybe_rules             OUT     sys.re$rule_hit_list);
24 
25   PROCEDURE evaluate(
26         rule_set_name           IN      varchar2,
27         evaluation_context      IN      varchar2,
28         event_context           IN      sys.re$nv_list := NULL,
29         table_values            IN      sys.re$table_value_list := NULL,
30         column_values           IN      sys.re$column_value_list := NULL,
31         variable_values         IN      sys.re$variable_value_list := NULL,
32         attribute_values        IN      sys.re$attribute_value_list := NULL,
33         simple_rules_only       IN      boolean := FALSE,
34         true_rules_iterator     OUT     binary_integer,
35         maybe_rules_iterator    OUT     binary_integer);
36 
37   PROCEDURE evaluate_expression(
38         rule_expression         IN      varchar2,
39         table_aliases           IN      sys.re$table_alias_list := NULL,
40         variable_types          IN      sys.re$variable_type_list := NULL,
41         table_values            IN      sys.re$table_value_list := NULL,
42         column_values           IN      sys.re$column_value_list := NULL,
43         variable_values         IN      sys.re$variable_value_list := NULL,
44         attribute_values        IN      sys.re$attribute_value_list := NULL,
45         cache                   IN      boolean := FALSE,
46         result_val              OUT     boolean);
47 
48   PROCEDURE is_fast (
49         expression              IN      varchar2,
50         table_aliases           IN      sys.re$table_alias_list := NULL,
51         variable_types          IN      sys.re$variable_type_list := NULL,
52         result_val              OUT     boolean);
53 
54   FUNCTION get_next_hit(
55         iterator                IN      binary_integer)
56   RETURN sys.re$rule_hit;
57 
58   PROCEDURE close_iterator(
59         iterator                IN      binary_integer);
60 
61 END dbms_rule;