Recent content by JEM

Thanks for the quick response, wish there was a better solution, but here is what I ended up with (which solves my problem for the time being as only 10% of records are larger than 4k) create or replace function blob_to_varchar2(b blob) return varchar2 is begin if (length(b) between 1 and...

I use a TOracleQuery to load some data with a blob field. It takes about 10 seconds to load 700 rows. Average blob size is around 3k, but some are as large as 64k. Oracle Monitor indicates most of the time spent is network latency due to many LOB.Length and LOB.Read() operations. Is there a way...