Long Raw

From: Randy Christiansen <randy_christiansen_at_auto-soft.com>
Date: Mon, 18 Sep 2000 17:06:31 -0600
Message-Id: <10623.117294@fatcity.com>

Hello Everybody,

Our JAVA app needs to log binary messages that will vary in size (5K to 100K).

We have discovered from Oracle Support (somehow that seems like an oxy-moron) using a BLOB we can only insert 4K at a time using a loop. Oracle is supposed to fix the preparedStatements.setbytes method in version 8.2 to remedy this problem.

Using the loop is an expensive solution for us, so we are trying to use Long Raw (BTW I found out that Long and Long Raw will be going away in 8.2) we can't figure out how to insert more than 4K into a Long Raw column. I've been searching the internet but hav'nt found anything yet.

Does anyone have any JAVA or PL/SQL code examples of how to do this?

Thanks,
Randy J. Christiansen
Oracle Guy
Brooks Automation - Autosoft Division
randy.christiansen_at_brooks.com Received on Mon Sep 18 2000 - 18:06:31 CDT