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 such as create and update. A temporary LOB, being a temporary component, must be freed-up as soon as its related actions are over. The DBMS_LOB package provides the APIs to handle temporary LOB actions.
Managing temporary LOBs
The DBMS_LOB package...
