OPEN procedures - Open a large object

The OPEN procedures are a no-op.

Syntax

Read syntax diagramSkip visual syntax diagramDBMS_LOB.OPEN_BLOB( lob_loc,open_mode)
Read syntax diagramSkip visual syntax diagramDBMS_LOB.OPEN_CLOB( lob_loc,open_mode)

Parameters

lob_loc
An input or output argument of type BLOB(10M) or CLOB(10M) that specifies the large object locator of the large object to be opened.
open_mode
An input argument of type INTEGER that specifies the mode in which to open the large object. Set to 0 (lob_readonly) for read-only mode. Set to 1 (lob_readwrite) for read-write mode.

Authorization

EXECUTE privilege on the DBMS_LOB module.