public static String oracleClob2Str(Clob clob) throws Exception { return (clob != null ? clob.getSubString(1, (int) clob.length()) : null); }