../E14919-04.epub /> ../E14919-04.mobi />

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