Re: [cinjug-users] Returning 4K+ from a Java Stored Procedure

[Eric Bardes <ericbardes@xxxxxxxxx>]

It's been over 2 years since I've used Oracle, but I remember a
similar problem getting binary photo data from a blob.

At the heart of our solution was to use ResultSet.getBinaryStream("columnindex")
There is a ResultSet.getAsciiScream() too.

The idiom went:

int bytes;
ResultSet rs = ...

while (rs.next())
{
   InputStream is = rs.getBinaryStream("photo");
   while ((bytes = is.read( ... )) > 0)
   {
       ...
   }
}


--
Cheers,
Eric Bardes