The function ora-lob-erase
erases part of the LOB pointed to by lob-locator. That is, it fills part of the LOB with 0 for BLOBs or spaces for CLOBs.
The operation starts from offset offset into the LOB and erases amount of data in the LOB, or to the end of the LOB. Note that the offset starts from 1, and that offset and amount are in characters for CLOBs and bytes for BLOB.
Erasing does not extend beyond the end of the LOB. The return value erased is the number of characters or bytes erased. erased will be smaller than amount if the sum of offset and amount is greater than the length of the LOB.
ora-lob-erase
is applicable to internal LOBs only.
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
.
ora-lob-erase
is available only when the "oracle" module is loaded. See the section Oracle LOB interface for more information.LispWorks User Guide and Reference Manual - 13 Feb 2015