Trim (OraLOB) Method


Trims or truncates the LOB value to shorter length.


OraBlob.Trim NewLen
OraClob.Trim NewLen


The arguments for the method are:

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


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


When manipulating LOBs using LOB methods, such as the Write and CopyFromFile, the LOB object is not automatically trimmed if the length of the new data is shorter than the old data. Use the Trim (OraLOB) method to shrink the LOB object to the size of the new data.