jdbc & 4k insert transfer limit?

From: Mark W Modrall <modrall_at_world.std.com>
Date: Mon, 14 Aug 2000 22:05:20 GMT
Message-ID: <FzAyow.GBx@world.std.com>

Hi...

i've got a little database that i'm trying to populate with the output from a program of mine... I've heard about the 4k column size limit trying to use the oracle odbc drivers (though it doesn't make much sense, i know the limit exists), but i would have thought that jdbc wouldn't be so hobbled.

However, whenever i try to send up an INSERT operation with a column bigger than 4000 bytes, it complains... Anyone know how to get around this limitation? Are CLOBs and separate clob insertion routines the only way to go?

thanks
-mark Received on Mon Aug 14 2000 - 17:05:20 CDT