messages-and-message-schemas-for-biztalk-adapter-for-oracle-database.md

title	description	ms.custom	ms.date	ms.service	ms.reviewer	ms.suite	ms.topic
Messages and Message Schemas for BizTalk Adapter for Oracle Database	XML structure of messages and data types used by the Oracle Database adapter for BizTalk Server		06/08/2017	biztalk-server			article

Messages and Message Schemas for BizTalk Adapter for Oracle Database

Overview

The [!INCLUDEadapteroracle] is a [!INCLUDEfirstref_btsWinCommFoundation] custom binding. It exposes operations that applications can invoke on it and that it can, in turn, invoke on applications. These operations are invoked by sending SOAP messages over a channel. If a response is required, it is returned in a SOAP message over the same channel.

As a [!INCLUDEnextref_btsWinCommFoundation] service, the [!INCLUDEadapteroracle_short] exposes metadata for its operations and data types by using standard [!INCLUDEnextref_btsWinCommFoundation] mechanisms. The sections in this topic describe the XML structure of the messages and data types that the [!INCLUDEadapteroracle_short] uses.

In This Section

• Basic Oracle Data Types

• Message Schemas for the Basic Insert, Update, Delete, and Select Operations on Tables and Views

• Message Schemas for Special LOB Operations

• Message Schemas for Functions and Procedures

• Message Schemas for REF CURSORS

• Message Schemas for RECORD Types

• Message Schemas for the SQLEXECUTE Operation

• Message Schemas for the Polling Operations

• Message Schemas for the Composite Operation

• Message Schemas for the Notification Operation