jdbc Clob
 

Hi all,

Im using java 5, and PreparedStatements to insert a Clob object into Oracle DB. PreparedStatement has a method to set clob for a record, but I see no way of creating the Clob object itself. Im using the Clob to read a huge document and insert it to the DB.

Ive read that we need to insert a record with a blank clob, and then update it with the actual clob value. Is this true?

Does anyone have any examples?

Thanks

raven

The specific Java version (JDK 1.5 vs JDK 1.4.2, for example) or Oracle version (8.x, or something much more recent) shouldn't matter. This link should help:

http://www.csee.umbc.edu/help/oracle...85/samapp2.htm