READ procedures

The READ procedures provide the capability to read a portion of a large object into a buffer.

Syntax


1  READ_BLOB ( lob_loc , amount , offset , buffer )

1  READ_CLOB ( lob_loc , amount , offset , buffer )

Parameters

lob_loc
An input argument of type BLOB(10M) or CLOB(10M) that specifies the large object locator of the large object to be read.
amount
An input or output argument of type INTEGER that specifies the number of bytes or characters to read.
offset
An input argument of type INTEGER that specifies the position to begin reading. The first byte or character is at position 1.
buffer
An output argument of type BLOB(32762) or VARCHAR(32672) that specifies the variable to receive 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.