| Oracle® Database PL/SQL Packages and Types Reference 11g Release 2 (11.2) Part Number E25788-04 |
|
|
PDF · Mobi · ePub |
| Oracle® Database PL/SQL Packages and Types Reference 11g Release 2 (11.2) Part Number E25788-04 |
|
|
PDF · Mobi · ePub |
This chapter describes the types used with rules, rule sets, and evaluation contexts.
This chapter contains the following topics:
Overview
Security Model
This section contains topics that relate to using the types used with rules, rule sets, and evaluation contexts.
This types in this chapter are used in rules and enable clients to evaluate rules with the rules engine.
See Also:
Oracle Streams Extended Examples for examples that use rule types
PUBLIC is granted EXECUTE privilege on the types described in this chapter.
| Type | Description |
|---|---|
|
Specifies the value of a variable attribute |
|
|
Identifies a list of attribute values |
|
|
Specifies the value of a table column |
|
|
Identifies a list of column values |
|
|
Identifies a list of names |
|
|
Identifies a list of name-value pairs |
|
|
Identifies an object containing a list of name-value pairs and methods that operate on this list. This object type is used to represent the event context and the action context for a rule |
|
|
Identifies a name-value pair |
|
|
Specifies a rule found because of evaluation |
|
|
Identifies a list of rules found because of evaluation |
|
|
Provides the table corresponding to an alias used in a rule evaluation context |
|
|
Identifies a list of table aliases used in a rule evaluation context |
|
|
Specifies the value of a table row using a |
|
|
Identifies a list of table values |
|
|
Provides the type of a variable used in a rule evaluation context |
|
|
Identifies a list of variables and their types used in a rule evaluation context |
|
|
Specifies the value of a variable |
|
|
Identifies a list of variable values |
Rule types are used with the following Oracle-supplied PL/SQL packages:
DBMS_RULE
DBMS_RULE_ADM
You can use the DBMS_RULE_ADM package to create and administer rules, rule sets, and evaluation contexts, and you can use the DBMS_RULE package to evaluate rules.
When you use Oracle Streams, rules determine which changes are captured by a capture process, which messages are propagated by a propagation, which messages are applied by an apply process, and which messages are dequeued by a messaging client. The following Oracle Streams packages use rules:
DBMS_APPLY_ADM
DBMS_CAPTURE_ADM
DBMS_PROPAGATION_ADM
DBMS_STREAMS
DBMS_STREAMS_ADM
DBMS_STREAMS_AUTH
Specifies the value of a variable attribute.
Note:
Enclose the variable name and attribute name in double quotation marks (") if the name contains special characters.TYPE SYS.RE$ATTRIBUTE_VALUE ( variable_name VARCHAR2(32), attribute_name VARCHAR2(4000), attribute_value ANYDATA);
Table 256-2 RE$ATTRIBUTE_VALUE Attributes
| Attribute | Description |
|---|---|
|
|
Specifies the variable used in a rule |
|
|
Specifies the attribute name. The attribute name can be a multi-component name, such as |
|
|
Specifies the attribute value |
Identifies a list of attribute values.
TYPE SYS.RE$ATTRIBUTE_VALUE_LIST AS VARRAY(1024) OF SYS.RE$ATTRIBUTE_VALUE;
Specifies the value of a table column.
Note:
Enclose the column name in double quotation marks (") if the name contains special characters.TYPE SYS.RE$COLUMN_VALUE ( table_alias VARCHAR2(32), column_name VARCHAR2(4000), column_value ANYDATA);
Table 256-3 RE$COLUMN_VALUE Attributes
| Attribute | Description |
|---|---|
|
|
Specifies the alias used for the table in a rule |
|
|
Specifies the column name |
|
|
Specifies the column value |
Identifies a list of column values.
TYPE SYS.RE$COLUMN_VALUE_LIST AS VARRAY(1024) OF SYS.RE$COLUMN_VALUE;
Identifies a list of names.
TYPE SYS.RE$NAME_ARRAY AS VARRAY(1024) OF VARCHAR2(30);
Identifies a list of name-value pairs.
TYPE SYS.RE$NV_ARRAY AS VARRAY(1024) OF SYS.RE$NV_NODE;
Identifies an object containing a list of name-value pairs and methods that operate on this list. This object type is used to represent the event context for rule set evaluation and the action context for a rule.
TYPE SYS.RE$NV_LIST AS OBJECT( actx_list SYS.RE$NV_ARRAY);
This section describes the following member procedures and member functions of the SYS.RE$NV_LIST type:
Adds a name-value pair to the list of name-value pairs.
Note:
Enclose the name in double quotation marks (") if the name contains special characters.MEMBER PROCEDURE ADD_PAIR( name IN VARCHAR2, value IN ANYDATA);
Table 256-5 ADD_PAIR Procedure Parameters
| Parameter | Description |
|---|---|
|
|
The name in the name-value pair being added to the list. If the name exists in the list, then this procedure raises an error. |
|
|
The value in the name-value pair being added to the list |
Returns a list of all the names in the name-value pair list.
MEMBER FUNCTION GET_ALL_NAMES() RETURN SYS.RE$NAME_ARRAY;
Returns the value for the specified name in a name-value pair list.
Note:
Enclose the name in double quotation marks (") if the name contains special characters.MEMBER FUNCTION GET_VALUE( name IN VARCHAR2) RETURN ANYDATA;
Table 256-6 GET_VALUE Procedure Parameters
| Parameter | Description |
|---|---|
|
|
The name whose value to return |
Removes the name-value pair with the specified name from the name-value pair list.
Note:
Enclose the name in double quotation marks (") if the name contains special characters.MEMBER PROCEDURE REMOVE_PAIR( name IN VARCHAR2);
Table 256-7 REMOVE_PAIR Procedure Parameters
| Parameter | Description |
|---|---|
|
|
The name of the pair to remove |
Identifies a name-value pair.
Note:
Enclose the name in double quotation marks (") if the name contains special characters.TYPE SYS.RE$NV_NODE ( nvn_name VARCHAR2(30), nvn_value ANYDATA);
Table 256-8 RE$NV_NODE Attributes
| Attribute | Description |
|---|---|
|
|
Specifies the name in the name-value pair |
|
|
Specifies the value in the name-value pair |
Specifies a rule found because of an evaluation.
See Also:
TYPE SYS.RE$RULE_HIT ( rule_name VARCHAR2(65), rule_action_context RE$NV_LIST);
Table 256-9 RE$RULE_HIT Attributes
| Attribute | Description |
|---|---|
|
|
The rule name in the form |
|
|
The rule action context as specified in the |
Identifies a list of rules found because of an evaluation.
TYPE SYS.RE$RULE_HIT_LIST AS VARRAY(1024) OF SYS.RE$RULE_HIT;
Provides the table corresponding to an alias used in a rule evaluation context. A specified table name must satisfy the schema object naming rules.
Note:
Enclose the table name in double quotation marks (") if the name contains special characters.See Also:
Oracle Database SQL Language Reference for information about schema object naming rulesTYPE SYS.RE$TABLE_ALIAS IS OBJECT( table_alias VARCHAR2(32), table_name VARCHAR2(194));
Table 256-10 RE$TABLE_ALIAS Attributes
| Attribute | Description |
|---|---|
|
|
The alias used for the table in a rule |
|
|
The table name referred to by the alias. A synonym can be specified. The table name is resolved in the evaluation context schema. The format is one of the following: schema_name.table_name table_name For example, if the hr.employees |
Identifies a list of table aliases used in a rule evaluation context.
TYPE SYS.RE$TABLE_ALIAS_LIST AS VARRAY(1024) OF SYS.RE$TABLE_ALIAS;
Specifies the value of a table row using a ROWID.
TYPE SYS.RE$TABLE_VALUE( table_alias VARCHAR2(32), table_rowid VARCHAR2(18));
Table 256-11 RE$TABLE_VALUE Attributes
| Attribute | Description |
|---|---|
|
|
Specifies the alias used for the table in a rule |
|
|
Specifies the rowid for the table row |
Identifies a list of table values.
Note:
Each table alias in the list in the list must be unique.TYPE SYS.RE$TABLE_VALUE_LIST AS VARRAY(1024) OF SYS.RE$TABLE_VALUE;
Provides the type of a variable used in a rule evaluation context. A specified variable name must satisfy the schema object naming rules.
Note:
Enclose the variable name in double quotation marks (") if the name contains special characters.See Also:
Oracle Database SQL Language Reference for information about schema object naming rulesTYPE SYS.RE$VARIABLE_TYPE ( variable_name VARCHAR2(32), variable_type VARCHAR2(4000), variable_value_function VARCHAR2(228), variable_method_function VARCHAR2(228));
Table 256-12 RE$VARIABLE_TYPE Attributes
| Attribute | Description |
|---|---|
|
|
The variable name used in a rule |
|
|
The type that is resolved in the evaluation context schema. Any valid Oracle built-in data type, user-defined type, or Oracle-supplied type can be specified. See the Oracle Database SQL Language Reference for more information about these types. |
|
|
A value function that can be specified for implicit variables. A synonym can be specified. The function name is resolved in the evaluation context schema. It is executed on behalf of the owner of a rule set using the evaluation context or containing a rule that uses the evaluation context. See the "Usage Notes" for more information. |
|
|
Specifies a value function, which can return the result of a method invocation. Specifying such a function can speed up evaluation, if there are many simple rules that invoke the method on the variable. The function can be a synonym or a remote function. The function name is resolved in the evaluation context schema. It is executed on behalf of the owner of a rule set using the evaluation context or containing a rule that uses the evaluation context. See the "Usage Notes" for more information. |
The functions for both the for the variable_value_function parameter and variable_method_function parameter have the following format:
schema_name.package_name.function_name@dblink
Any of the following parts of the format can be omitted: schema_name, package_name, and @dblink.
For example, if the schema_name is hr, the package_name is var_pac, the function_name is func_value, and the dblink is dbs1.net, then enter the following:
hr.var_pac.func_value@dbs1.net
The following sections describe the signature of the functions.
Signature for variable_value_function
The function must have the following signature:
FUNCTION variable_value_function_name(
evaluation_context_schema IN VARCHAR2,
evaluation_context_name IN VARCHAR2,
variable_name IN VARCHAR2,
event_context IN SYS.RE$NV_LIST )
RETURN SYS.RE$VARIABLE_VALUE;
Signature for variable_method_function
This function must have the following signature:
FUNCTION variable_method_function_name(
evaluation_context_schema IN VARCHAR2,
evaluation_context_name IN VARCHAR2,
variable_value IN SYS.RE$VARIABLE_VALUE,
method_name IN VARCHAR2,
event_context IN SYS.RE$NV_LIST)
RETURN SYS.RE$ATTRIBUTE_VALUE;
Identifies a list of variables and their types used in a rule evaluation context.
TYPE SYS.RE$VARIABLE_TYPE_LIST AS VARRAY(1024) OF SYS.RE$VARIABLE_TYPE;
Specifies the value of a variable.
Note:
Enclose the variable name in double quotation marks (") if the name contains special characters.TYPE SYS.RE$VARIABLE_VALUE ( variable_name VARCHAR2(32), variable_data ANYDATA);
Table 256-13 RE$VARIABLE_VALUE Attributes
| Attribute | Description |
|---|---|
|
|
Specifies the variable name used in a rule |
|
|
Specifies the data for the variable value |
Identifies a list of variable values.
TYPE SYS.RE$VARIABLE_VALUE_LIST AS VARRAY(1024) OF SYS.RE$VARIABLE_VALUE;
|
 Copyright © 1996, 2011, Oracle and/or its affiliates. All rights reserved. Legal Notices |
|