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 |
---|---|---|
|
|
The resource name of the invalidated object in the format < |
|
|
The information about the database event that occurs on a resource |
|
|
The rowid for the invalidated table row |
|
|
The |
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_ID
s that are registered with it.
For Continuous Query Notification:
The Details
property indicates changes for each invalidated object in the notification in the data table.
If ROWID
information is requested, then the ROWID
information is populated into the Rowid
column. However, if many rows are modified in a table, then the whole table is invalidated, and ROWID
information is not provided. Therefore, the Rowid
column contains all Null
values.
If the database event is related to a DDL change of the table or a table drop, then the Rowid
column is set to Null
.