GETLENGTH v16

The GETLENGTH function returns the length of a large object.

<amount> INTEGER GETLENGTH(<lob_loc> BLOB)

<amount> INTEGER GETLENGTH(<lob_loc> CLOB)

Parameters

lob_loc

Large object locator of the large object whose length to obtain.

amount

Length of the large object for BLOB or characters for CLOB, in bytes.