Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to Convert a java.sql.CLOB object to String

 
Ankit Gandhi
Greenhorn
Posts: 27
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I have a PL/SQL procedure �reorganize_report� which returns a CLOB object. This proc is being called through a java file named ReportDAO.java in the following way-

csmt = con.prepareCall("{call report_spk.reorganize_report(?,?,?,?) }");
csmt.setObject(1,(Object)reportId,java.sql.Types.CHAR);
csmt.registerOutParameter(7,java.sql.Types.CLOB);
csmt.registerOutParameter(8,java.sql.Types.CLOB);
csmt.registerOutParameter(9,java.sql.Types.CLOB);
csmt.execute();


I am retrieving the Clob�s like this � (the CLOB object is of java.sql.CLOB class)
Clob sourcelocationLst = csmt.getClob(7);
Clob newlocationLst = csmt.getClob(8);
Clob fileNameLst = csmt.getClob(9);

Now I need to convert this CLOB into a String object.
I tried using the toString() function present for CLOB�s but it gives me the following o/p - oracle.sql.CLOB@66c9b250

Can anybody help me out with this?
 
Freddy Wong
Ranch Hand
Posts: 959
Eclipse IDE Java Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If you look at the java.sql.Clob, there's a method called getCharacterStream() that returns a Reader. You can use the Reader and convert it into String.

Hope that helps.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic