Oracle Advanced PL/SQL Developer Professional Guide

Using temporary LOBs

Temporary LOBs provide a temporary solution to hold a LOB data in a limited scope—maximum up to a SESSION. It can be used in a PL/SQL block as a local variable. A temporary LOB created using the DBMS_LOB package resides in temporary tablespace. Note that neither the redo logs nor the rollback information is generated for it. For this reason, they yield better performance within a block.

A temporary LOB can be created as any of the internal LOBs, but cannot be initialized using empty LOB locator constructor methods (EMPTY_CLOB and EMPTY_BLOB). They can be a handy solution when manipulative operations are performed on the LOB type column in a PL/SQL block.

Temporary LOB operations

A temporary LOB allows most of the LOB operations ...