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 10-25.

Table 10-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:

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.