9 Distributed LOBs
This section describes the ways in which you can work with LOB data in remote tables.
See Also:
Sharding with LOBs- Working with Remote LOBs in SQL and PL/SQL
This section describes the SQL and PL/SQL functions that are supported on remote LOBs. - Using the Data Interface on Remote LOBs
The data interface enables you to bind and define aCHARACTER
buffer for aCLOB
column and aRAW
buffer for aBLOB
column. This interface is supported for remote LOB columns too. - Working with Remote Locators
You can select a persistent LOB locator from a remote table into a local variable and this can be done in any programmatic interface like PL/SQL, JDBC or OCI. The remote columns can be of typeBLOB
,CLOB
orNCLOB
.