DB2 10.5 for Linux, UNIX, and Windows

GETLENGTH function - Return the length of the large object

The GETLENGTH function returns the length of a large object.

The function returns an INTEGER value that reflects the length of the large object in bytes (for a BLOB) or characters (for a CLOB).

Syntax

Read syntax diagramSkip visual syntax diagram
>>-DBMS_LOB.GETLENGTH--(--lob_loc--)---------------------------><

Parameters

lob_loc
An input argument of type BLOB(10M) or CLOB(10M) that specifies the large object locator of the large object whose length is to be obtained.

Authorization

EXECUTE privilege on the DBMS_LOB module.