Skip Headers
Oracle® Data Provider for .NET Developer's Guide
11g Release 2 (11.2.0.3)

Part Number E23174-02
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
PDF · Mobi · ePub

OracleNotificationEventArgs Class

The OracleNotificationEventArgs class provides event data for a notification.

Class Inheritance

System.Object

  System.EventArgs

    Oracle.DataAccess.Client.OracleNotificationEventArgs

Declaration

// C#
public sealed class OracleNotificationEventArgs

Thread Safety

All public static methods are thread-safe, although methods do not guarantee thread safety.

Requirements

Namespace: Oracle.DataAccess.Client

Assembly: Oracle.DataAccess.dll

ODP.NET Version: ODP.NET for .NET Framework 2.0 or ODP.NET for .NET Framework 4

Comment: Not supported in a .NET stored procedure


OracleNotificationEventArgs Members

OracleNotificationEventArgs members are listed in the following tables.

OracleNotificationEventArgs Static Fields

The OracleNotificationEventArgs static field is listed in Table 9-18.

Table 9-18 OracleNotificationEventArgs Static Field

Static Field Description

Empty

Inherited from System.EventArgs


OracleNotificationEventArgs Static Methods

The OracleNotificationEventArgs static method is listed in Table 9-19.

Table 9-19 OracleNotificationEventArgs Static Method

Static Method Description

Equals

Inherited from System.Object


OracleNotificationEventArgs Properties

OracleNotificationEventArgs properties are listed in Table 9-20.

Table 9-20 OracleNotificationEventArgs Properties

Properties Description

Details

Contains detailed information about the current notification

Info

Indicates the database events for the notification

ResourceNames

Indicates the database resources related to the current notification

Source

Returns the database event source for the notification

Type

Returns the database event type for the notification


OracleNotificationEventArgs Methods

OracleNotificationEventArgs methods are listed in Table 9-21.

Table 9-21 OracleNotificationEventArgs Methods

Methods Description

Equals

Inherited from System.Object

GetHashCode

Inherited from System.Object

GetType

Inherited from System.Object

ToString

Inherited from System.Object



OracleNotificationEventArgs Static Fields

The OracleNotificationEventArgs static field is listed in Table 9-22.

Table 9-22 OracleNotificationEventArgs Static Field

Static Field Description

Empty

Inherited from System.EventArgs



OracleNotificationEventArgs Static Methods

The OracleNotificationEventArgs static method is listed in Table 9-23.

Table 9-23 OracleNotificationEventArgs Static Method

Static Method Description

Equals

Inherited from System.Object



OracleNotificationEventArgs Properties

OracleNotificationEventArgs properties are listed in Table 9-24.

Table 9-24 OracleNotificationEventArgs Properties

Properties Description

Details

Contains detailed information about the current notification

Info

Indicates the database events for the notification

ResourceNames

Indicates the database resources related to the current notification

Source

Returns the database event source for the notification

Type

Returns the database event type for the notification


Details

This property contains detailed information about the current notification.

Declaration

// C#
Public DataTable Details{get;}

Property Value

A DataTable instance that contains detailed information about the current notification.

Remarks

The returned DataTable object contains column data about the current notification in order as shown in Table 9-25.

Table 9-25 DataTable Object Column Data

Name Type Description

ResourceName

System.String

The resource name of the invalidated object in the format <Schema_name>.<object_name>

Info

OracleNotificationInfo

The information about the database event that occurs on a resource

Rowid

System.String

The rowid for the invalidated table row

QueryId

Int32

The CHANGE_NOTIFICATION_QUERY_ID


The QueryId column contains the CHANGE_NOTIFICATION_QUERY_ID that corresponds to the pseudo-column that may have been retrieved by a SELECT statement at the time of the query-based notification. Also, the OracleDependency object maintains all the CHANGE_NOTIFICATION_QUERY_IDs that are registered with it.

For Continuous Query Notification:

Info

This property indicates the database events for the notification.

Declaration

// C#
public OracleNotificationInfo Info{get;}

Property Value

An OracleNotificationInfo value that indicates the database event for the notification.

Remarks

The OracleNotificationInfo value is an enumeration type. If several events are received from the invalidation message, the Info property is set to one of the OracleNotificationInfo enumeration values associated with the database events. For example, if a table has been altered and a new row has been inserted into another table, the Info property is set to either OracleNotificationInfo.Altered or OracleNotificationInfo.Insert.

To obtain more detailed information from the invalidation message, use the Details and the ResourceNames properties.

ResourceNames

This property indicates the database resources related to the current notification.

Declaration

// C#
public string[] ResourceNames{get;}

Property Value

A string array that indicates the database resources related to the current notification.

Remarks

For Continuous Query Notification, the ResourceNames property contains information about the invalidated object names in the format <schema_name>.<object _name>. To obtain more detailed information about the changes for invalidated objects, use the Details property.

Source

This property returns the database event source for the notification.

Declaration

// C#
public OracleNotificationSource Source{get;}

Property Value

The OracleNotificationSource value for the notification.

Remarks

The OracleNotificationSource value is an enumeration type. If several event sources are received from the notification message, the Source property is set to one of the OracleNotificationSource enumeration values related to the database event source. For example, if a table has been altered (by the ALTER TABLE command) and a new row has been inserted into the same table, the Source property is set to either OracleNotificationSource.Object or OracleNotificationSource.Data.

For Continuous Query Notification:

Type

This property returns the database event type for the notification.

Declaration

// C#
public OracleNotificationType Type{get;}

Property Value

An OracleNotificationType enumeration value that represents the type of the database event notification.

Remarks

The OracleNotificationType value is an enumeration type. If several event types are received from the notification message, then the Type property is set to one of the OracleNotificationType enumeration values related to the database event type.


OracleNotificationEventArgs Methods

OracleNotificationEventArgs methods are listed in Table 9-26.

Table 9-26 OracleNotificationEventArgs Methods

Methods Description

Equals

Inherited from System.Object

GetHashCode

Inherited from System.Object

GetType

Inherited from System.Object

ToString

Inherited from System.Object