A LOB locator.
A pathname designator.
A non-negative integer, or
nil
.
A non-negative integer, or
nil
.
A keyword or
nil
.
The function
ora-lob-read-into-plain-file
writes the contents of a LOB into a file.
file-name specifies the file to write, which should be a standard file. The file is always opened in a binary mode, so if the LOB is a CLOB, the file will be generated in the right format when reading it from the LOB.
offset
is the offset into the LOB from where to start reading. It starts from 1, counts characters in a CLOB, and if it is
nil
then the operation starts from the end of the previous read operation. The default value of
offset
is
nil
.
file-offset
specifies the offset into the file to start the operation from. If
file-offset
is
nil
then it starts writing at the start of the file. The default value of
file-offset
is
nil
.
if-exists
is passed to open when opening the file, with the standard Common Lisp meaning. The default value of
if-exists
is
:error
.
Note: this function is available only when the "oracle" module is loaded. See the section Oracle LOB interface for more information.