Java Stored Function returning byte[]

I am trying to return a byte array from a Java Stored function. When I call the SF from a java client JDBC CallableStatement (using a JDBC type 4 driver) the array returned is always 4098 bytes long. I know for a fact that the array is 100+kb

I have also tried returning the bytes as a RAW (oracle.sql.RAW) and BLOB (oracle.sql.BLOB) - and also tried returning the byte[] as an OUT param from the using a CallableStatement (which I believe crashed Oracle completely) I have looked in OTN and other sources for this error and the best I could find was a document explaining there is a 32kb limit on this type of call when using LONG and LONG RAW types. Using a PreparedStatement is listed as a solution but would be much too slow for what I need to do.

Is there some way to return larger byte arrays from a stored function using a CallableStatement ?

I am using the following configuration - Server = Oracle 8.1.5 on NT Server 4.0 sp 3 Client = NT Server 4.0 sp 3
JDK 1.2.2     DH

  -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------    http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Thu Jan 20 2000 - 01:13:53 CST