This week's book giveaway is in the Jython/Python forum.
We're giving away four copies of Murach's Python Programming and have Michael Urban and Joel Murach on-line!
See this thread for details.
Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

reading clob  RSS feed

 
pendse anagha
Ranch Hand
Posts: 44
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello ,
I have a huge text file which contains the emails and city .
There would be thousands of such records in the file .

I have uploaded the file into Oracle into a clob .

Now I want to read the clob and do some procesing for each line
i.e . : email,city

I want to get each line from the clob .

Could someone kindly point me to an example
Also what are the best practices while reading from clob ?

Thanks in advance ,
-anagha
 
Jeanne Boyarsky
author & internet detective
Sheriff
Posts: 36406
454
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Anagha,
The easest way is to call getCharacterStream() on the Clob. That way you can deal with the result as a familiar reader object.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!