Rules Manager uses the DBMS_RLMGR package, which contains various procedures, to create and manage rules and rule sessions. The following table describes the procedures in the DBMS_RLMGR package.
None of the values and names passed to the procedures defined in the DBMS_RLMGR package are case insensitive, unless otherwise mentioned. To preserve the case, enclose the values with double quotation marks.
Tip:
See the chapter on the DBMS_RLMGR package in Oracle Database PL/SQL Packages and Types Reference for all reference information concerning Rules Manager package procedures. Use the links in the Procedures column in Table 8-1 to see each procedure.Table 8-1 DBMS_RLMGR Procedures
| Procedure | Description |
|---|---|
|
Adds the specified attribute to the event structure and the Expression Filter attribute set |
|
|
Adds an event to a rule class in an active session |
|
|
Adds a function, a type, or a package to the approved list of functions with an event structure and to the Expression Filter attribute set |
|
|
Adds a rule to the rule class |
|
|
Retrieves the primitive rule condition reference from a rule condition for composite events |
|
|
Consumes an event using its identifiers and prepares the corresponding rule for action execution |
|
|
Consumes one or more primitive events with all or none semantics |
|
|
Creates a repository for the primitive rule conditions that can be shared by multiple rules from the same or different rule classes |
|
|
Creates an event structure |
|
|
Creates expression filter indexes for the rule class if the default indexes have been dropped |
|
|
Creates a rule class interface package to directly operate on the rule class |
|
|
Creates a rule class |
|
|
Deletes a rule from a rule class |
|
|
Drops the conditions table |
|
|
Drops an event structure |
|
|
Drops Expression Filter indexes for the rule conditions |
|
|
Drops the rule class interface package |
|
|
Drops a rule class |
|
|
Adds an attribute to the primitive event structure |
|
|
Retrieves the aggregate value computed for a collection event |
|
|
Grants a privilege on a rule class to another user |
|
|
Processes the rules for a given event |
|
|
Resets the rule class by removing all the events associated with the rule class and purging any state information pertaining to rules matching some events |
|
|
Starts a new rule session within a database session |
|
|
Revokes a privilege on a rule class from a user |
|
|
Synchronizes the indexes defined to process the predicates involving the |