This topic has not yet been rated - Rate this topic

Samples

Samples for Microsoft BizTalk Adapter 3.0 for Oracle Database are categorized into BizTalk samples, WCF service model samples, WCF channel model samples, and migration samples. The samples are available at http://go.microsoft.com/fwlink/?LinkId=106690. The SQL scripts for creating the tables, packages, etc. used in the samples are also available along with the samples for the Oracle Database adapter.

The following list contains the names and descriptions of the samples for the BizTalk Adapter Pack.

BizTalk Samples

Sample Directory Name	Description
Func_RecordTypes	Demonstrates how to use RECORD type parameters and return values in functions and procedures using the Oracle Database adapter.
Func_RefCursor	Demonstrates how to use REF CURSOR parameters in functions and procedures using the Oracle Database adapter.
InvokeFunction	Demonstrates how to invoke a function in Oracle database using the Oracle Database adapter.
InvokeOverloadedProc	Demonstrates how to invoke with overloaded functions and procedures in Oracle database using the Oracle Database adapter.
Operate_BFILE	Demonstrates how to use Oracle BFILE types in Oracle procedures using the Oracle Database adapter.
Operate_LOB	Demonstrates how to perform ReadLOB and UpdateLOB operations on tables with LOB data types using the Oracle Database adapter.
PollingQuery	Demonstrates how to configure a polling query and receive the results using the Oracle Database adapter.
SelectAccTable	Demonstrates how to perform a select query on an Oracle database table using the Oracle Database adapter.
SqlExec	Demonstrates how to perform parameterized queries using the SQLEXECUTE operation on an Oracle database using the Oracle Database adapter.

WCF Service Model Samples

Sample Directory Name	Description
OracleBfileTypeSM	Demonstrates how to use Oracle BFILE types in basic SQL operations surfaced for Oracle tables and as parameters to Oracle procedures.
OracleOverloadsSM	Demonstrates how to invoke overloaded functions and procedures in a package.
OraclePollingSM	Demonstrates how to configure a polling query and receive the results.
OracleRecordTypesSM	Demonstrates how to use RECORD type parameters and return values in functions and procedures.
OracleRefCursorsSM	Demonstrates how to use REF CURSOR parameters in functions and procedures

WCF Channel Model Samples

Sample Directory Name	Description
OraclePollingCM	Demonstrates how to configure a polling query and receive the results.
OracleStreaming	Demonstrates how to perform end-to-end streaming of LOB data using the UpdateLOB and table Select operations

Migration Samples

Sample Directory Name	Description
Oracle_Migration	Demonstrates how to use a BizTalk project created using the previous version of the Oracle database adapter and make it work with the WCF-based Oracle Database adapter.

Concepts

Development

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)