ora-lob-load-from-file dest-lob-locator src-lob-file amount &key src-offset dest-offset errorp
An internal LOB locator.
A file LOB locator.
A non-negative integer.
A non-negative integer.
A non-negative integer.
A generalized boolean.
The function
ora-lob-load-from-file
loads the data from the
src-lob-file
into the destination LOB pointed to by
dest-lob-locator
.
The source LOB must be a BFILE and the destination must be an internal LOB.
The details of the operation are determined by amount , src-offset and dest-offset . amount and dest-offset are in characters for CLOB/NCLOB and are in bytes for BLOB. src-offset is in bytes. The offsets start from 1. The default value of dest-offset is 1 and the default value of src-offset is 1.
No conversion is performed by
ora-lob-load-from-file
, so if the destination is a CLOB/NCLOB, the source must already be in the right format.
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 OCILobReadFromFile. The Oracle documentation is ambiguous on whether it is mandatory to open the source LOB before calling this function.
Note: this function is available only when the "oracle" module is loaded. See the section Oracle LOB interface for more information.