Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> updating CLOBs and BLOBs

updating CLOBs and BLOBs

From: ABAK Systemes <info_at_abaksystemes.fr>
Date: Mon, 28 May 2001 08:14:42 GMT
Message-ID: <3B12091A.C92427DB@abaksystemes.fr>

I use Orcale 8.1.5 with JDBC thin driver.  When I want to update a CLOB column in a table, I make something like that:
 out = clob.getAsciiOutputStream();
 out.write(source); // where source is a byte[]  out.close();

 That works but if I had previously a longer data in the database, the end of the data remains.
 Example:
 I store "abcdef"
 Then I store "xx"
 When I get back the value, I obtain "xxcdef"

 Should I override the data with an empty_clob before storing the new value ?

The same problem occurs with BLOBs.

 Any ideas ?
 Thanks.

-- 
leriche_at_abaksystemes.fr
ABAK Systèmes, ZI Le Rachat - BP 5 - 35890 LAILLE
Tel: +33(0) 299.42.30.10, Fax: +33(0) 299.42.31.57
Received on Mon May 28 2001 - 03:14:42 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US