8 DBMS_RLMGR Package

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
ADD_ELEMENTARY_ATTRIBUTE procedure	Adds the specified attribute to the event structure and the Expression Filter attribute set
ADD_EVENT procedure	Adds an event to a rule class in an active session
ADD_FUNCTIONS procedure	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
ADD_RULE procedure	Adds a rule to the rule class
CONDITION_REF function	Retrieves the primitive rule condition reference from a rule condition for composite events
CONSUME_EVENT function	Consumes an event using its identifiers and prepares the corresponding rule for action execution
CONSUME_PRIM_EVENTS function	Consumes one or more primitive events with all or none semantics
CREATE_CONDITIONS_TABLE procedure	Creates a repository for the primitive rule conditions that can be shared by multiple rules from the same or different rule classes
CREATE_EVENT_STRUCT procedure	Creates an event structure
CREATE_EXPFIL_INDEXES procedure	Creates expression filter indexes for the rule class if the default indexes have been dropped
CREATE_INTERFACE procedure	Creates a rule class interface package to directly operate on the rule class
CREATE_RULE_CLASS procedure	Creates a rule class
DELETE_RULE procedure	Deletes a rule from a rule class
DROP_CONDITIONS_TABLE procedure	Drops the conditions table
DROP_EVENT_STRUCT procedure	Drops an event structure
DROP_EXPFIL_INDEXES procedure	Drops Expression Filter indexes for the rule conditions
DROP_INTERFACE procedure	Drops the rule class interface package
DROP_RULE_CLASS procedure	Drops a rule class
EXTEND_EVENT_STRUCT	Adds an attribute to the primitive event structure
GET_AGGREGATE_VALUE function	Retrieves the aggregate value computed for a collection event
GRANT_PRIVILEGE procedure	Grants a privilege on a rule class to another user
PROCESS_RULES procedure	Processes the rules for a given event
PURGE_EVENTS procedure	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
RESET_SESSION procedure	Starts a new rule session within a database session
REVOKE_PRIVILEGE procedure	Revokes a privilege on a rule class from a user
SYNC_TEXT_INDEXES procedure	Synchronizes the indexes defined to process the predicates involving the `CONTAINS` operator in rule conditions