CLOSE

The CLOSE procedure is used to close an internally or externally LOB that was previously opened.

Syntax

DBMS_LOB.CLOSE (
lob_loc    IN OUT NOCOPY BLOB);

DBMS_LOB.CLOSE (
lob_loc    IN OUT NOCOPY CLOB CHARACTER SET ANY_CS);

Parameters

Considerations

• CLOSE requires a round trip to the server for both internal and external LOB operations. For internal LOB operations, CLOSE triggers other code that depends on the close call.

• It is not mandatory to wrap all LOB operations within the Open/Close interface. If a LOB is opened, it must be closed before committing the transaction, otherwise an error will occur. When closing an internal LOB, the function-based and domain-based indexes on the LOB column will be updated.

• Submitting a transaction before closing all LOB objects opened by the transaction will result in an error. When an error occurs, the opened LOB objects will be discarded, but the transaction will still successfully commit all changes made to LOB and non-LOB data within the transaction. However, the domain-based and function-based indexes will not be updated. In such cases, you should rebuild the function-based and domain-based indexes on the LOB column.