Insert into LONG RAW?
Date: 1996/08/09
Message-ID: <NEWTNews.839621239.30865.rs6_at_rs6.inel.gov>#1/1
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:
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?
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!
ID VARCHAR2(8) NOT NULL
DATA LONG RAW
(That is, just from an INSERT statement.) Also, when
I try to select the data from this table with a
Name: Robert K. Smith
E-mail: rs6_at_inel.gov
(208) 526-5801
Received on Fri Aug 09 1996 - 00:00:00 CEST