Notification Operation Message Schemas
The Microsoft BizTalk Adapter for Oracle Database surfaces the Notification operation to receive database change notifications from the Oracle database.
You configure the Notification operation by setting binding properties in the Oracle Database adapter. For more information about the Notification-related binding properties, see Read about the Oracle Database adapter binding properties. You set the NotificationStatement binding property to specify a SELECT statement for the query notification.
Message Structure for the Notification Operation
The following table shows the XML message structure for the Notification operation.
| Operation | XML Message | Description |
|---|---|---|
| Notification | <?xml version="1.0" encoding="utf-8" ?> <Notification xmlns="http://Microsoft.LobServices.OracleDB/2007/03/Notification"> <Info>Value</Info> <Source>Value</Source> <Type>Value</Type> </Notification> |
This is the inbound message that is sent by the Oracle database to the adapter clients. In the message: - The <Info> tag indicates the reason for the notification. For example, an “insert” value in this tag indicates that data has been inserted in one or more of the tables referenced in the notification statement.- The <Source> tag indicates the source for the notification. For example, a “data” value in this tag indicates a change in the data in a referenced object. Similarly, an “object” value in this tag indicates a change in a referenced object.- The <Type> tag indicates the type of data change. For example, an “Update” value in the <Type> tag indicates that the results of the query have been updated. |
Message Action for the Notification Operation
The message action for the notification operation is “<http://Microsoft.LobServices.OracleDB/2007/03/Notification”>.
See Also
Messages and Message Schemas for BizTalk Adapter for Oracle Database