wb_lob_length
integer wb_lob_length(resource lob)
Parameters
-
lob
- An open LOB, the result of the wb_result function in the WB_LOBMODE_RESOURCE mode, or one of the array items returned by the wb_fetch_into function.
Description
Returns the length of the lob LOB in characters.
Characters are:
- 8-bit ASCII characters for CLOB
- 16-bit UCS-2 characters for NCLOB
- 8-bit binary characters for BLOB.
Returns
Returns the length of the lob LOB in characters.
Example
Display the length of a CLOB:
$cursor=wb_exec($connection,"SELECT clob_column FROM clob_table WHERE id=1");
wb_set_lob_mode($cursor,WB_LOBMODE_RESOURCE);
wb_fetch_into($cursor,$rec);
echo "Length of the CLOB is ".wb_lob_length($rec["CLOB_COLUMN"])."\n";
Viz
