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

ora-lob-trim Function

Summary

Trims an internal LOB.

Package

sql

Signature

ora-lob-trim lob-locator new-size &key errorp

Arguments
lob-locator
A LOB locator.
new-size
A non-negative integer.
errorp
A generalized boolean.
Description

The function ora-lob-trim trims the LOB pointed to by lob-locator to a new size new-size, which must be smaller than its current size.

Note that new-size is in characters for CLOBs and bytes for BLOBs.

ora-lob-trim 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.

Notes
  1. This is a direct call to OCILobTrim.
  2. ora-lob-trim 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