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

ora-lob-file-exists Function

Summary

The predicate for whether a LOB file exists.

Package

sql

Signature

ora-lob-file-exists lob-locator &key errorp => result

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

The function ora-lob-file-exists returns t if the file associated with lob-locator exists. This function is applicable only to file LOBs (CFILE or BFILE).

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 OCILobFileExists.
  2. ora-lob-file-exists is available only when the "oracle" module is loaded. See the section 23.11 Oracle LOB interface for more information.

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