OPEN

The OPEN procedure is used to open an internal or external LOB in a 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 a round trip to the internal and external LOB servers. For internal LOB objects, the OPEN procedure triggers other code that depends on the OPEN call.

• It is not mandatory to wrap all LOB operations in 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-based and domain-based indexes 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 status of the LOB will be discarded, but the transaction will still be committed, including 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.