This diagram illustrates the tasks involved in finding the length of LOBs. To get the length of the LOB you must first create a temporary LOB. After the task you need to free the temporary LOB.
Optionally you can open the LOB before getting the length of the LOB. If you open the LOB you must also close it when done.