TRIM

The TRIM stored procedure trims the value of an internal LOB to the length specified by the newlen parameter.

The TRIM stored procedure specifies the length in bytes for a BLOB and the length in characters for a CLOB.

If you attempt to trim an empty LOB, no result is returned, and the TRIM procedure does not return an error. If the new length specified by the newlen parameter exceeds the size of the LOB, an exception is raised.

Syntax

DBMS_LOB.TRIM (
lob_loc        IN OUT  NOCOPY BLOB,
newlen         IN             INTEGER);

DBMS_LOB.TRIM (
lob_loc        IN OUT  NOCOPY CLOB CHARACTER SET ANY_CS,
newlen         IN             INTEGER);

Parameters

Exceptions

Considerations

• You do not have to wrap LOB operations in the Open/Close interface. If you do not open the LOB before executing the operation, the functional index and domain index on the LOB column are updated during the call. If you open the LOB before executing the operation, you must close it before committing the transaction. When you close an internal LOB, the functional index and domain index on the LOB column are updated.

• If you do not wrap LOB operations in the Open/Close API, the functional index and domain index on the LOB column are updated each time you write to the LOB. To avoid performance issues, we recommend that you include LOB write operations in OPEN or CLOSE statements.

• If the new length is not 0, TRIM obtains the LOB before changing its length.