DB2 10.5 for Linux, UNIX, and Windows

ERASE procedures - Erase a portion of a large object

The ERASE procedures provide the capability to erase a portion of a large object.

To erase a large object means to replace the specified portion with zero-byte fillers for BLOBs or with spaces for CLOBs. The actual size of the large object is not altered.

Syntax

Read syntax diagramSkip visual syntax diagram
>>-DBMS_LOB.ERASE_BLOB--(--lob_loc--,--amount--+-----------+---->
                                               '-,--offset-'   

>--)-----------------------------------------------------------><


Read syntax diagramSkip visual syntax diagram
>>-DBMS_LOB.ERASE_CLOB--(--lob_loc--,--amount--+-----------+---->
                                               '-,--offset-'   

>--)-----------------------------------------------------------><

Parameters

lob_loc
An input or output argument of type BLOB(10M) or CLOB(10M) that specifies the large object locator of the large object to be erased.
amount
An input or output argument of type INTEGER that specifies the number of bytes or characters to be erased.
offset
An optional input argument of type INTEGER that specifies the position in the large object where erasing is to begin. The first byte or character is at position 1. The default is 1.

Authorization

EXECUTE privilege on the DBMS_LOB module.