Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Writing to CLOB with java
First of all, I don't know a thing about java. But what I can tell you is that we set a "Autocommit" property to false, you execute your SQL adding FOR UPDATE, and you create a stream object with GetCharacterStream.
hope that help
pat
US wrote in message <8fv07u$dmg_at_chronicle.concentric.net>...
>say, Patrick,
>Did you manage to find the solution for this problem? I"ve got *exactly*
the
>same
>problem...
>
>US
>
>Patrick Joyal <please.reply_at_to.the.newsgroup> wrote in message
>news:3921a820_at_news...
>> Does someone have example of how to write
>> to CLOB fields in java, using streams?
>>
>> when opening the recordset using a ordinary SQL query, we got
>> a message saying "Row containing the LOB value is not locked".
>> if we use a FOR UPDATE query, we have a "fetch out of sequence" error.
>>
>> thanks
>>
>> Patrick
>>
>>
>>
>
>
Received on Thu May 18 2000 - 00:00:00 CDT