This week's book giveaway is in the Design forum.
We're giving away four copies of Design for the Mind and have Victor S. Yocco on-line!
See this thread for details.
Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Reading CLOB object from Oracle

 
Parameswaran Thangavel
Ranch Hand
Posts: 485
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
All,
I am reading the String from my Oracle database which is stored as CLOB object.

below is the code snippet.

//columnNumber for the CLOB column in the database
oracle.sql.CLOB clob = (oracle.sql.CLOB)rs.getClob(columnNumber);

//Works fine for below line
//java.sql.CLOB clob = (java.sql.CLOB)rs.getClob(columnNumber);
inputStream = clob.asciiStreamValue();
int available = inputStream.available();

//available is zero for Oracle.sql.CLOB, but contains the value for java.sql.CLOB
byte[] buf = new byte[available];
int bytesRead = inputStream.read(buf);
inputStream.close();
//Printing the string object
System.out.println(new String(buf));


The above code works fine for SQL databse, but when i use the Oracle CLOB object its not returning any value. The variable available is zero for Oracle
but has the correct value for SQL database.

Any insight would help.

Thanks
Param
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic