Skip Headers
Oracle® Database Rules Manager and Expression Filter Developer's Guide
11g Release 2 (11.2)

Part Number E14919-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

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