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 .

Note: This is a direct call to OCILobFileGetName.

Note: this function is available only when the "oracle" module is loaded. See the section Oracle LOB interface for more information.