All Manuals > LispWorks® User Guide and Reference Manual > 45 The SQL Package

ora-lob-open Function

Summary

Opens a LOB.

Package

sql

Signature

ora-lob-open lob-locator &key errorp

Arguments
lob-locator
A LOB locator.
errorp
A generalized boolean.
Description

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.

Notes
  1. This is a direct call to OCILobOpen.
  2. ora-lob-open is available only when the "oracle" module is loaded. See the section 23.11 Oracle LOB interface for more information.
See also

ora-lob-close
ora-lob-is-open


LispWorks® User Guide and Reference Manual - 01 Dec 2021 19:30:56