String to Clob conversion

I don't have that jar file, but got it working with this,

protected static Clob createClob( Connection conn, String value )

throws SQLException

{

CallableStatement stmt = null;

try {

stmt = conn.prepareCall( "{ call DBMS_LOB.CREATETEMPORARY(?, TRUE)}" );

stmt.registerOutParameter( 1, oracle.jdbc.OracleTypes.CLOB );

stmt.execute();

Clob newClob = (Clob) stmt.getObject( 1 );

newClob.setString( 1, value );

return newClob;

} finally {

stmt.close();

}

}

moonsita at 2007-7-9 6:01:54 >