Uninitialized Collection Error when sending multiples of 64K bytes to Stored Procedure using JDBC

Home -> Community -> Usenet -> c.d.o.misc -> Uninitialized Collection Error when sending multiples of 64K bytes to Stored Procedure using JDBC

From: Susan Anderson <sca_at_arinc.com>
Date: 30 Sep 2002 13:38:31 -0700
Message-ID: <7f73d0b1.0209301238.508a9bc3@posting.google.com>

We recently discovered an Oracle bug, for which Oracle is writing a patch. In the meantime, we're looking for a workaround. We found that when we send an Oracle ARRAY via JDBC that has a size that is a multiple of 64K (resulting in the last four bytes of the size parameter being 00 00), we get an uninitialized collection.

Has anyone else had this problem and do you have a work-around? We tried using the .getLength() method for the ARRAY to get the size and break apart the ARRAY if it is a multiple of 64K, but .getLength is returning 0 in our case. Received on Mon Sep 30 2002 - 15:38:31 CDT