Edit

Notification Operation Message Schemas

  • Article

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