OPEN

The OPEN procedure is used to open an internal or external LOB in the specified mode. Valid modes include read-only and read/write.

Syntax

DBMS_LOB.OPEN (
lob_loc   IN OUT NOCOPY BLOB,
open_mode IN            BINARY_INTEGER);

DBMS_LOB.OPEN (
lob_loc   IN OUT NOCOPY CLOB CHARACTER SET ANY_CS,
open_mode IN            BINARY_INTEGER);

Parameters

Considerations

• The OPEN procedure requires communication between the internal and external LOB servers. For internal LOB types, the OPEN procedure triggers other code that depends on the OPEN call.

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

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