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 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
ora-lob-openis available only when the "oracle" module is loaded. See the section Oracle LOB interface for more information.
LispWorks User Guide and Reference Manual - 13 Feb 2015