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

ora-lob-file-get-name Function

Summary

Returns the directory and name for the file associated with a file LOB.

Package

sql

Signature

ora-lob-file-get-name lob-locator &key errorp => dir, filename

Arguments
lob-locator
A LOB locator.
errorp
A generalized boolean.
Values
dir
A string of length no greater than 30.
filename
A string of length no greater than 255.
Description

The function ora-lob-file-get-name returns as multiple values the directory alias dir and the filename filename associated with the LOB denoted by lob-locator. The 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 OCILobFileGetName.
  2. ora-lob-file-get-name 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