Re: Selecting LONG RAWs

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Wed, 17 Jul 2002 22:43:51 GMT
Message-ID: <3D35F2EC.62082B40@exesolutions.com>

Anthony Jackson wrote:

> 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)

I hope you meant a 32K limit on VARCHAR2.

LONG RAW is binary information ... think C or Java.

But, as Oracle is dropping them, you should to. Use CLOB and BLOB instead and use the DBMS_LOB package for access.

For more info go to http://tahiti.oracle.com and search for DBMS_LOB.

Daniel Morgan Received on Wed Jul 17 2002 - 17:43:51 CDT