OracleNotificationRequest Class

An OracleNotificationRequest class represents a notification request to be subscribed in the database. It contains information about the request and the characteristics of the notification. Using the OracleNotificationRequest class, Oracle Data Provider for .NET can create the notification registration in the database.

Class Inheritance

System.Object

  Oracle.DataAccess.Client.OracleNotificationRequest

Declaration

// C#
public sealed class OracleNotificationRequest

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

Microsoft .NET Framework Version: 1.x or 2.0

Comment: Not supported in a .NET stored procedure

---

OracleNotificationRequest Members

OracleNotificationRequest members are listed in the following tables:

OracleNotificationRequest Static Method

The OracleNotificationRequest static method is listed in Table 8-12.

OracleNotificationRequest Properties

OracleNotificationRequest properties are listed in Table 8-13.

OracleNotificationRequest Methods

OracleNotificationRequest methods are listed in Table 8-14.

---

OracleNotificationRequest Static Methods

The OracleNotificationRequest static method is listed in Table 8-15.

---

OracleNotificationRequest Properties

The OracleNotificationRequest properties are listed in Table 8-16.

IsNotifiedOnce

This property indicates whether or not the registration is to be removed upon notification.

Declaration

// C#
public bool IsNotifiedOnce{get; set;}

Property Value

A bool value that indicates whether or not the registration is to be removed upon notification.

Remarks

Default is true.

Modifying this property after the completion of a successful registration has no effect.

IsPersistent

This property indicates whether or not the invalidation message should be queued persistently in the database before delivery.

Declaration

// C#
public bool IsPersistent{get; set;}

Property Value

A bool value that indicates whether or not the invalidation message should be queued persistently in the database before delivery.

When the IsPersistent property is set to True, the message is queued persistently in the database and cannot be lost upon database failures or shutdowns. When the IsPersistent property is set to False, the message is stored in an in-memory queue before delivery and could be lost.

This property does not apply to NotificationRegistration which is always persistent.

This property only applies to the notification message after it has been sent.

Remarks

Default is false.

Modifying this property after the completion of a successful registration has no effect.

The database performs faster if the message is stored in an in-memory queue rather than a database queue.

Timeout

This property specifies the time, in seconds, that the registration remains alive.

Declaration

// C#
public long Timeout{get; set}

Property Value

A long value that specifies the time, in seconds, that the registration remains alive. The valid values for the Timeout property are between 0 and 4294967295. The default is 50000.

Exceptions

ArgumentOutOfRangeException - The specified Timeout is invalid.

Remarks

Modifying this property after the completion of a successful registration has no effect.

When the Timeout property is set to 0, the registration does not expire.

When the registration is removed because the registration has expired, the database sends a notification indicating the expiration.

---

OracleNotificationRequest Methods

OracleNotificationRequest methods are listed in Table 8-17.