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. In order to preserve the case, double quotation marks should be used around the values.
Tip:
See the "DBMS_RLMGR" chapter in Oracle Database PL/SQL Packages and Types Reference for all reference information concerning Rules Manager package procedures.Table 7-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 (also the Expression Filter attribute set) |
|
Adds a rule to the rule class |
|
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 an event structure |
|
Creates a rule class |
|
Deletes a rule from a rule class |
|
Drops an event structure |
|
Drops a rule class |
|
Grants a privilege on a rule class to another user |
|
Processes the rules for a given event |
|
Starts a new rule session within a database session |
|
Revokes a privilege on a rule class from a user |