The function
ora-lob-open
opens the LOB pointed to by
lob-locator
, which can be an internal LOB or a file LOB.
Opening the LOB creates a transaction, so any updates associated with modifying the LOB are delayed until the ora-lob-close call. This saves round-trips and avoids extra work on the server side. However it is not mandatory to use
ora-lob-open
.
Calls to
ora-lob-open
must be strictly paired to calls to ora-lob-close, and the latter must be called before a call to commit. It is also an error to call
ora-lob-open
on a server LOB object that is already open, even if it has been opened via a different LOB locator.
If an error occurs and
errorp
is true, an error is signaled. If
errorp
is false, the function returns an object of type sql-database-error. The default value of
errorp
is
nil
.
Note: This is a direct call to OCILobOpen.
Note: this function is available only when the "oracle" module is loaded. See the section Oracle LOB interface for more information.