Oracle.sql.Clob type conversion to String type

Method One:

 PublicString clobtostring (Clob Clob)throwsSQLException, IOException {String restring= ""; Reader is= Clob.getcharacterstream ();//Get the FlowBufferedReader br =NewBufferedReader (IS); String s=Br.readline (); StringBuffer SB=NewStringBuffer ();  while(s! =NULL) {//the execution loop takes all the strings out and pays the value to StringBuffer from StringBuffer to stringSb.append (s); S=Br.readline (); } restring=sb.tostring (); returnrestring;}

Method Two:

/*** Oracle's CLOB turns into a string *@paramCLOB *@return */ PublicString oracleclobtostring (CLOB CLOB) {Try {        return(Clob = =NULL?NULL: Clob.getsubstring (1, (int) (Clob.length ())); } Catch(SQLException e) {e.printstacktrace (); }    return NULL;}

Oracle.sql.Clob type conversion to String type