Trim (OraLOB) Method

Applies To

OraBLOB, OraCLOB

Description

Trims or truncates the LOB value to shorter length.

Arguments

[in] NewLen
An Integer specifying the new length of the LOB value which must be less than or equal to the current length.
Usage

OraBlob.Trim newlen

OraClob.Trim newlen

Remarks

Either a row-level lock or object-level lock should be obtained before calling this method.

Note: When manipulating LOBs using LOB methods, such as the Write and CopyFromFile, note that the LOB object will not automatically be trimmed if the length of the new data is smaller than the old data. Use the
Trim (OraLob) method to shrink the LOB object to the size of the new data.