Samples for the Oracle Database adapter
Samples for Microsoft BizTalk Adapter for Oracle Database are categorized into:
BizTalk Server samples
WCF service model samples
WCF channel model samples
The samples are available at BizTalk Adapter Pack 2010: Oracle Database adapter samples. The SQL scripts for creating the tables and packages used in the samples are included.
Note
These samples need updated to the current version. Interested in updating them? If yes, then add your updated samples to our public GitHub repo at https://github.com/Microsoft/Integration.
The following list describes the samples.
BizTalk Server 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 |
| OracleTransactedDmlSM | Demonstrates how to perform operations on the Oracle database in a transaction using the WCF service model. |
WCF channel model samples
| 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. |