Thursday 21 October 2010

insertClob

/**
  * http://www.coderanch.com/t/295768/JDBC/java/inserting-large-file-CLOB-Oracle
  * @param clob
  * @param value
  * @throws Exception
  */
 public void insertClob(oracle.sql.CLOB clob, String value) throws Exception {
  try {
   OutputStream outstream = clob.getAsciiOutputStream();
   outstream.flush();
   outstream.write(value.getBytes());
   outstream.close();
  } catch (Exception e) {
   e.printStackTrace();
  }
 }