Writing Clobs with the thin driver

From: Cookie Monster <cookie.monster_at_somewhere.com>
Date: Thu, 11 Nov 2004 13:16:03 +0100
Message-ID: <2vh3g4F2kmf5sU1@uni-berlin.de>

Hi,

I have a problem with the oracle thin driver writing clobs greater then 4000 chars. Basically using the oci driver the following java code works fine:

PreparedStatement statement;
  Reader bodyReader = null;
  try {
   bodyReader = new StringReader(parameter.toString());    statement.setCharacterStream(1,bodyReader,parameter.toString().length());
} catch (Exception e) {

   e.printStackTrace();
   throw new SQLException("Failed to set text field.");
}

But when using with the thin driver nothing gettings written to the clob. Does anyone know a solution to this problem where I can use the thin driver for writing clobs??

Thanks,
Steve. Received on Thu Nov 11 2004 - 06:16:03 CST