3 out of 3 rated this helpful - Rate this topic

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.

In This Section

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)