WRITE procedures

The WRITE procedures provide the capability to write data into a large object.

Any existing data in the large object at the specified offset for the given length is overwritten by data given in the buffer.

Syntax

WRITE_BLOB(lob_loc,amount,offset,buffer)
WRITE_CLOB(lob_loc,amount,offset,buffer)

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 written.
amount
An input argument of type INTEGER that specifies the number of bytes or characters in buffer to be written to the large object.
offset
An input argument of type INTEGER that specifies the offset in bytes or characters from the beginning of the large object for the write operation to begin. The start value of the large object is 1.
buffer
An input argument of type BLOB(32767) or VARCHAR(32672) that contains the data to be written to the large object. If lob_loc is a BLOB, then buffer must be BLOB. If lob_loc is a CLOB, then buffer must be VARCHAR.