Export (0) Print
Expand All

Samples

Samples for Microsoft BizTalk Adapter for Oracle Database are categorized into:

  • BizTalk Server samples

  • WCF service model samples

  • WCF channel model samples

  • Migration samples

The samples are available at http://go.microsoft.com/fwlink/?LinkID=196854. 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 Oracle Database adapter.

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.

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

OracleTransactedDmlSM

Demonstrates how to perform operations on the Oracle database in a transaction using the WCF service model.

Sample Directory Name Description

OraclePollingCM

Demonstrates how to configure a polling query and receive the results.

OracleStreamingDemo

Demonstrates how to perform end-to-end streaming of LOB data using the UpdateLOB and table Select operations

OracleTransactedDmlCM

Demonstrates how to perform operations on the Oracle database in a transaction using the WCF channel model.

Sample Directory Name Description

Oracle_Migration

Demonstrates how to use a BizTalk project created using the BizTalk ODBC Adapter for Oracle Database (shipped with BizTalk Server) and make it work with the WCF-based Oracle Database adapter (shipped with BizTalk Adapter Pack 2010 ).

Show:
© 2014 Microsoft