DB2 10.5 for Linux, UNIX, and Windows

WRITE procedures - Write data to a large object

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


>>-DBMS_LOB.WRITE_BLOB--(--lob_loc--,--amount--,--offset--,--buffer--)-><


>>-DBMS_LOB.WRITE_CLOB--(--lob_loc--,--amount--,--offset--,--buffer--)-><

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.

EXECUTE privilege on the DBMS_LOB module.