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.