This week's book giveaway is in the Big Data forum.
We're giving away four copies of Elasticsearch in Action and have Radu Gheorghe & Matthew Lee Hinman on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes Regarding clob Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Elasticsearch in Action this week in the Big Data forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Regarding clob" Watch "Regarding clob" New topic
Author

Regarding clob

Navin Pillu
Ranch Hand

Joined: Apr 19, 2005
Posts: 103
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

Joined: Dec 20, 2006
Posts: 2531
    
  10

Navin Pillu wrote:...
I tried setClob, setAsciiStream. But both functions throw the exception.
...
Can you tell us what that Exception says?


OCUP UML fundamental and ITIL foundation
youtube channel
 
wood burning stoves
 
subject: Regarding clob