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

ora-lob-file-set-name Function

Summary

Sets the name of a file LOB.

Package

sql

Signature

ora-lob-file-set-name file-lob-locator dir-alias name &key errorp

Arguments
file-lob-locator
A file LOB locator.
dir-alias
A string or nil.
name
A string or nil.
errorp
A generalized boolean.
Description

The function ora-lob-file-set-name sets the directory alias and the name of the file LOB pointed to by file-lob-locator.

If dir-alias is a string it should be of length no greater than 30. If it is nil then the directory alias of the file LOB is not changed.

If name is a string it should be of length no greater than 255. If it is nil then the name of the file LOB is not changed.

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 OCILobFileSetAlias.
  2. ora-lob-file-set-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