Edit

Develop your Oracle Database applications

  • Article

Overview

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.

BizTalk vs WCF service vs WCF channel

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 Insert, update, delete, or select operations using BizTalk Server with Oracle Database Insert, update, delete, or select operations in Oracle Database using the WCF Service Model Run an Insert Operation in Oracle Database using the WCF Channel Model
Operations on tables and views containing LOB data Run operations on tables with large object data types in Oracle Database Complete operations on tables with large data types in Oracle Database using the WCF service model
Operations on functions and stored procedures Invoke Functions and Procedures in Oracle Database using BizTalk Server Invoke Functions and Procedures in Oracle Database using the WCF Service Model Invoke a Function in Oracle Database using the WCF Channel Model
Invoking overloaded functions and procedures Invoke Overloaded Functions and Procedures in Oracle Database using BizTalk Server Invoke Functions and Procedures in Oracle Database using the WCF Service Model
Operations on functions and procedures With REF CURSOR parameters Invoke Functions and Procedures with REF CURSORS in Oracle Database using BizTalk Server Run Operations Using REF CURSORS in Oracle Database using the WCF Service Model
Operations on functions and procedures with RECORD types Invoke Functions and Procedures with RECORD Types in Oracle Database using BizTalk Server Run Operations Using RECORD Types in Oracle Database using the WCF Service Model
Operations on tables and views with BFILE data types Run operations on Tables with BFILE Data Types in Oracle Database using BizTalk Server
SQLEXECUTE operation Run SQLEXECUTE operation in Oracle Database using BizTalk Server Run SQLEXECUTE operation in Oracle Database using the WCF Service Model Run a SQLEXECUTE Operation in Oracle Database using the WCF Channel Model
Receiving polling-based data-change messages Poll Oracle Database using BizTalk Server Receive Polling-based Data-changed Messages in Oracle Database using the WCF Service Model Receive Polling-based Data-changed Messages in Oracle Database using the WCF Channel Model
Performing Composite Operations on the Oracle Database Run Composite Operations on Oracle Database using BizTalk Server
Receiving Database Change Notifications Receive Oracle Database Change Notifications Using BizTalk Server Receive Oracle Database Change Notifications Using the WCF Service Model1

Next steps

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.