• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Regarding clob

 
Navin Pillu
Ranch Hand
Posts: 103
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All

I've a clob in my oracle DB. It has a length of 18000 chars. I've a requirement where I need to copy it from one schema to another. It is getting retrieved but not able to insert into another schema through batch through JDBC.

I tried setClob, setAsciiStream. But both functions throw the exception. These functions work fine for chars less than 10000.

Can anybody tell me how to do it.

Thanks

Regards
Navin
 
Jan Cumps
Bartender
Posts: 2588
11
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Navin Pillu wrote:...
I tried setClob, setAsciiStream. But both functions throw the exception.
...
Can you tell us what that Exception says?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic