LispWorks User Guide and Reference Manual > 38 The SQL Package

NextPrevUpTopContentsIndex

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 .

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.

See also

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


LispWorks User Guide and Reference Manual - 22 Dec 2009

NextPrevUpTopContentsIndex