Export (0) Print
Expand All

Development

The Microsoft BizTalk Adapter for Oracle Database is a Windows Communication Foundation (WCF) custom binding. Client applications can consume the Oracle Database adapter to invoke operations on Oracle database artifacts. The Oracle Database adapter can be consumed:

  • Through a physical port binding in a BizTalk Server solution.

  • By invoking methods on an instance of a .NET client proxy.

  • As a hosted WCF service.

  • By sending SOAP messages over a channel instance in code that uses the WCF channel model.

The following table:

  • Lists the different operations that can be performed on an Oracle database using the Oracle Database adapter.

  • Provides links to the topics containing information about performing the task using the chosen approach (BizTalk Server, WCF service model, or WCF channel model).

Task BizTalk Server WCF Service Model WCF Channel Model

Basic Insert, Update, Delete, and Select operations on tables and views

Performing Basic Insert, Update, Delete, and Select Operations by Using BizTalk Server

Performing Basic Insert, Update, Delete, and Select Operations by Using the WCF Service Model

Performing an Insert Operation by Using the WCF Channel Model

Operations on tables and views containing LOB data

Performing Operations on Tables with Large Object Types Data by Using BizTalk Server

Performing Operations on Tables with Large Object Types by Using the WCF Service Model

Operations on functions and stored procedures

Invoking Functions and Procedures by Using BizTalk Server

Invoking Functions and Procedures by Using the WCF Service Model

Invoking a Function by Using the WCF Channel Model

Invoking overloaded functions and procedures

Invoking Overloaded Functions and Procedures by Using BizTalk Server

Invoking Functions and Procedures by Using the WCF Service Model

Operations on functions and procedures With REF CURSOR parameters

Invoking Functions and Procedures with REF CURSORS by Using BizTalk Server

Performing Operations Using REF CURSORS in the WCF Service Model

Operations on functions and procedures with RECORD types

Invoking Functions and Procedures with RECORD Types by Using BizTalk Server

Performing Operations Using RECORD Types in the WCF Service Model

Operations on tables and views with BFILE data types

Performing Operations on Tables with BFILE Data Types by Using BizTalk Server

SQLEXECUTE operation

Performing a SQLEXECUTE Operation by Using BizTalk Server

Performing a SQLEXECUTE Operation by Using the WCF Service Model

Performing a SQLEXECUTE Operation by Using the WCF Channel Model

Receiving polling-based data-change messages

Polling Oracle Database by Using BizTalk Server

Receiving Polling-based Data-changed Messages by Using the WCF Service Model

Receiving Polling-based Data-changed Messages by Using the WCF Channel Model

Performing Composite Operations on the Oracle Database

Performing Composite Operations on Oracle Database by Using BizTalk Server

Receiving Database Change Notifications

Receiving Database Change Notifications Using BizTalk Server

Receiving Database Change Notifications Using the WCF Service Model

The topics in this section provide information, procedures, and examples to help you develop applications that consume the Oracle Database adapter in both BizTalk Server and .NET programming solutions. The topics also provide information on other key aspects of using the adapters, such as:

  • Connecting to the Oracle database.

  • Retrieving metadata from the Oracle database.

  • Using binding properties to configure the adapter.

Show:
© 2014 Microsoft