Hi Tom,

Here is my query to check the temporary lob.

select sum(cache_lobs) sum_cache_lobs from v$temporary_lobs;

SUM_CACHE_LOBS
--------------
0

This is my simple standalone function with return type clob

CREATE OR REPLACE FUNCTION SAMP_FUN
RETURN CLOB
IS
BEGIN
RETURN 'TESTCLOB';
END;
/

1. when I run this function in sql developer the cache lob increased by 1.

select sum(cache_lobs) sum_cache_lobs from v$temporary_lobs;

SUM_CACHE_LOBS
--------------
1

It got cleared when I did disconnect and reconnect the connection.

2. when I run the same function in sql* plus the cache lob is not increased.

3. We have an application that uses connection pool . It calls oracle methods returning clob.
The cache_lobs are not cleared until I do the application restart(the same behavior as it was in sql developer).
Any input to clear the cache lobs in the application without doing application restart would be very helpful