Re: Insert into LONG RAW?

You can do it from PL/SQL block but there are limitations on the size of the object.
If you do it either from Pro*C (there is a good example in the Oracle sample directory with the name sample4) or OCI the size of the object then will be limited by the amount of memory you have on your machine.  

To use Pro*C you'll have to install it first, though OCI is already there, Pro*C is easy to use.

In order to read the object in SQL*Plus you will have to write your own program and call it from either PL/SQL(using DBMS_PIPE) or from the operating system.

Hope this will help

In article <NEWTNews.839621239.30865.rs6_at_rs6.inel.gov>, rs6_at_inel.gov says:
>
>
>I'm trying how to figure out how to use the INSERT
>statement to load data into a LONG RAW column. My
>table TESTRS6 is as follows:
>
>ID VARCHAR2(8) NOT NULL
>DATA LONG RAW
>
>I've found that
>
>INSERT INTO TESTRS6 VALUES ('A1', HEXTORAW('41'));
>
>seems to work fine for one byte, but I really
>need to load a rather large binary file. I know
>there must be a way to do this, but can it be done
>without using some other database to load from?
>(That is, just from an INSERT statement.) Also, when
>I try to select the data from this table with a
>
>SELECT DATA FROM TESTRS6;
>
>I get a message that I'm trying to use incompatible
>data types, or something like that. I'd greatly
>appreciate any info you could pass along on this!
>
>
>-------------------------------------
>Name: Robert K. Smith
>E-mail: rs6_at_inel.gov
>(208) 526-5801
>
Received on Mon Aug 12 1996 - 00:00:00 CEST