Develop your Oracle Database applications

 

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).

TaskBizTalk ServerWCF Service ModelWCF Channel Model
Basic Insert, Update, Delete, and Select operations on tables and viewsInsert, update, delete, or select operations using BizTalk Server with Oracle DatabaseInsert, update, delete, or select operations in Oracle Database using the WCF Service ModelRun an Insert Operation in Oracle Database using the WCF Channel Model
Operations on tables and views containing LOB dataRun operations on tables with large object data types in Oracle DatabaseComplete operations on tables with large data types in Oracle Database using the WCF service model
Operations on functions and stored proceduresInvoke Functions and Procedures in Oracle Database using BizTalk ServerInvoke Functions and Procedures in Oracle Database using the WCF Service ModelInvoke a Function in Oracle Database using the WCF Channel Model
Invoking overloaded functions and proceduresInvoke Overloaded Functions and Procedures in Oracle Database using BizTalk ServerInvoke Functions and Procedures in Oracle Database using the WCF Service Model
Operations on functions and procedures With REF CURSOR parametersInvoke Functions and Procedures with REF CURSORS in Oracle Database using BizTalk ServerRun Operations Using REF CURSORS in Oracle Database using the WCF Service Model
Operations on functions and procedures with RECORD typesInvoke Functions and Procedures with RECORD Types in Oracle Database using BizTalk ServerRun Operations Using RECORD Types in Oracle Database using the WCF Service Model
Operations on tables and views with BFILE data typesRun operations on Tables with BFILE Data Types in Oracle Database using BizTalk Server
SQLEXECUTE operationRun SQLEXECUTE operation in Oracle Database using BizTalk ServerRun SQLEXECUTE operation in Oracle Database using the WCF Service ModelRun a SQLEXECUTE Operation in Oracle Database using the WCF Channel Model
Receiving polling-based data-change messagesPoll Oracle Database using BizTalk ServerReceive Polling-based Data-changed Messages in Oracle Database using the WCF Service ModelReceive Polling-based Data-changed Messages in Oracle Database using the WCF Channel Model
Performing Composite Operations on the Oracle DatabaseRun Composite Operations on Oracle Database using BizTalk Server
Receiving Database Change NotificationsReceive Oracle Database Change Notifications Using BizTalk ServerReceive Oracle Database Change Notifications Using the WCF Service Model1

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: