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
>>-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.