Bizzarre Clob field problem?

From: harry <a_at_abc.com>
Date: Fri, 16 Jun 2006 09:01:17 GMT
Message-ID: <xrukg.86862$wl.36160@text.news.blueyonder.co.uk>

Oracle 10.1.0.3.0 running on Solaris 9

My table contains 10 Clob fields which hold HTML code, this is inserted using something like

PreparedStatement ps = etc..............;

            clob = CLOB.createTemporary(conn, false, CLOB.DURATION_SESSION);
            clob.setString(1, sections[1]);
            ps.setClob(1, clob);

where sections[] hold the various pieces of HTML

What's totally bizarre is the correct HTML is definitely going in to the Clob fields but on reading it comes out different - like it's been replaced with the data from other Clob fields!

This works perfectly on Oracle 9.2.0.1.0 running on Win 2000 but not on 10.1.0.3.0

I have absolutely no idea what's going on - totally stumped! - can anyone shed some light on this?

many thanks (hope I've explained it clearly!)

harry Received on Fri Jun 16 2006 - 04:01:17 CDT