How to shrink a BLOB in Java/JDBC?

I can see how to write to a BLOB from a Java/JDBC application or stored procedure, but it isn't at all clear if it is possible to truncate a BLOB.

In my case, I am writing an array of values and I often find it necessary to append to the end of the array. No problem. Sometimes, I need to remove some of the values from the end of the array. Naturally, I can use some kind of length indicator inside the BLOB and simply ignore everything after a point, but I was hoping to use the BLOB.length() method to determine how many values are in the array without actually reading it.

Is there any way to do this besides re-writing an entirely new BLOB? Received on Tue Aug 03 1999 - 21:25:18 CDT