Operations on Tables and Views That Contain LOB Data

The Microsoft BizTalk Adapter for Oracle Database provides support for the Oracle large object (LOB) data types:

On the Oracle database, LOB data types are used to store large amounts of data (up to 4 GB). LOB types support both input and output streaming.

The Microsoft BizTalk Adapter for Oracle Database surfaces the following operations for tables and views that contain LOB columns:

  • ReadLOB. The ReadLOB operation is surfaced for tables and views that contain BLOB, CLOB, NCLOB, and BFILE columns. By using the ReadLOB operation, adapter clients can read values in a LOB column as a data stream. This operation takes the LOB data type column name and a filter string as parameters. Adapter clients must ensure that the filter string fetches exactly one matching row. If there is more than one matching row, the Oracle Database adapter only returns the LOB column for the first (matching) row.

    noteNote
    The ReadLOB operation is designed to support input streaming of LOB data in the WCF service model. You should use a table Select operation to read LOB data from a WCF Channel Model or BizTalk Server solution. For more information about streaming, see Streaming Support for LOB Data Types.

  • UpdateLOB. The UpdateLOB operation is surfaced for tables and views that contain BLOB, CLOB, and NCLOB columns. By using the UpdateLOB operation, adapter clients can update values in a LOB column. This operation takes the LOB data type column name, a filter string, and base64binary encoded data as parameters. Adapter clients must ensure that the filter string fetches exactly one matching row; otherwise the Oracle Database adapter throws an XmlReaderParsingException.

    noteNote
    The UpdateLOB operation:

noteNote
ReadLOB and UpdateLOB operate on a single LOB column in a single table row. To operate on LOB columns in multiple rows or on multiple LOB columns within a single row, you must invoke ReadLOB or UpdateLOB for each target column within each target row.

For more information about:

See Also

© 2014 Microsoft Corporation. All rights reserved.
Show: