about insert clob column
1 posts in topic
Flat View  Flat View

Posted By:   tao_taiqiang
Posted On:   Wednesday, June 20, 2001 02:12 AM

I want to insert a clob value into a table.I use oracle8im, jdk1.3 . I use the oracle example, but always has a error "ORA-01002: fetch out of sequence" . The value, i want to insert, only 3000byte(approach). What shoud I do?

Re: about insert clob column

Posted By:   David_Unknown  
Posted On:   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:
- myConn.commit();

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...
About | Sitemap | Contact