Re: about insert clob column
Monday, June 25, 2001 09:49 AM
Oh, I had exactly the same problem a week ago!
The thing is that you have to deactivate the autocommit mode. In code:
- myConn.setAutoCommit(false); and after the insert call the commit() method:
Also remember that the select sentence, that fetch the record that after is used to write the array of character data to the CLOB, must end with the words FOR UPDATE.
Hope this helps you...