Selecting LONG RAWs

From: Anthony Jackson <ajackson_at_et.byu.edu>
Date: Wed, 17 Jul 2002 13:43:52 -0600
Message-ID: <3D35C8F8.7090306@et.byu.edu>

After reading up some on LONG RAWs I found out that a LONG RAW column can store upto 2gb, but a PL/SQL LONG RAW has a 32k limit.

So, How can I SELECT a LONG RAW > 32k in PL/SQL?

Is there a way to do it like dbms_lob does?

Is there a way to get all 2GBs using Java, ProC or *cringe* OCI?

BTW, I'm on 8i (8.1.7), upgrading to 9i is not an option, converting LONG RAWs to BLOBs is not an option (although *I* would have done both an long time ago).

Thanks in advance,

Anthony
(please see my related post from yesterday) Received on Wed Jul 17 2002 - 14:43:52 CDT