[Opensource] Opensource] Trouble with CLOB field when Writing/Reading data size > 4000

Rick Goeltz goeltzrt at ornl.gov
Wed Jun 11 13:42:21 PDT 2003


Hi Jennifer:

 > I got the following Exception when inserting/updating
 > a CLOB field with data size greater than 4000

I once inserted BLOBs (PDF) into Oracle (V8) using straight JDBC.  A 
procedure specific to Oracle was necessary where the record was created 
with a null BLOB, then the record was fetched and the BLOB field updated 
using a stream.  All according to Oracle documentation.  Perhaps you face a 
similar situation.

Let me know if you'd like a pointer to additional documentation (I don't 
have it in front of me at the moment).

Rick




More information about the Opensource mailing list