5
Advanced Topics

The material in this chapter is a supplement and elaboration of the use cases described in the following chapters.You will probably find the topics discussed here to be more relevant once you have explored the use cases.

• Read-Consistent Locators
  • A Selected Locator Becomes a Read Consistent Locator

  • Updated LObs Via Updated Locators

  • Example of Updating a LOB Using SQL DML and DBMS_LOB

  • Example of Using One Locator to Update the Same LOB Value

  • Example of Updating a LOB with a PL/SQL (DBMS_LOB) Bind Variable

  • LOB Locators Cannot Span Transactions

  • LOB Locators and Transaction Boundaries

• LOBs in the Object Cache

• LOB Buffering Subsystem
  • Advantages of LOB Buffering

  • Guidelines for Using LOB Buffering

  • LOB Buffering Usage Notes

  • OCI Example of LOB Buffering

• Creating a Varray Containing References to LOBs

Note: Examples in this chapter are based on the multimedia schema and table Multimedia_tab described in Chapter 8, "Sample Application".