CLOB objects in JDBC/Oracle 8i

From: JP Moresmau <jeffries_at_indigo.ie>
Date: Thu, 4 Nov 1999 16:25:36 -0000
Message-ID: <7vsbq8$54g$1@kermit.esat.net>

Hi all,
I'm playing around with Clobs through JDBC (thin driver). I'm connecting back to an Oracle 8i on HP-UX.
I can read the CLOB all right using the getCharacterStream() method, but I can't write to it: if I follow the documentation (selecting the CLOB and writing to the stream using getCharacterOutputStream()) I get a

ORA-22920: row containing the LOB value is not locked error.
If I add a "for update" at the end of my select statement, I get a

ORA-01002: fetch out of sequence
error.

Heeeeeeeeelp, anyone?

Thanks a million.

JP Moresmau
jpmor_at_gofree.indigo.ie Received on Thu Nov 04 1999 - 10:25:36 CST