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
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
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
is true, an error is signaled. If
is false, the function returns an object of type sql-database-error. The default value of