EMPTY_[B | C]LOB

Syntax

Purpose

EMPTY_BLOB and EMPTY_CLOB returns an empty LOB locator that can be used to initialize a LOB variable or in an INSERT or UPDATE statement to initialize a LOB column or attribute to EMPTY. EMPTY means that the LOB is initialized, but not populated with data.

You cannot use the locator returned from this function as a parameter to the DBMS_LOB package or the OCI.

Example

INSERT INTO lob_tab1 VALUES (EMPTY_BLOB());
UPDATE lob_tab1 

SET clob_col = EMPTY_BLOB();