Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> sqlload'ing pictures

sqlload'ing pictures

From: Jon Gorrono <jpgorrono_at_ucdavis.edu>
Date: 1997/02/13
Message-ID: <3303A08D.3968@ucdavis.edu>#1/1

I am having a hernia trying to load some graphics files into a table...this is my first such attempt, and my experience with the loader and oracle is not extensive. Any help would be greatly appreciated.

I set up a two-column table (id, pic) where id is an integer (on which I created an index) and pic is LONG RAW.

I have tried a number of control files, but the latest looks something like
LOAD DATA
INFILE "picdir/roth.gif" FIXED 13774 <- log file says this is parsed

I get error 402: unable to determine length of column pic from spec.

yet I cannot specify a length in the column spec for creating the LONG RAW column and RAW alone is not (or will not be) big enough.

Any means to the desired end accepted, but there must be a direct way to read variable length binary data files directly into columns(?).

Thanks for your ear,
JP

-- 
______________________________________________________________
Jon Gorrono (Gorro&ntilde;o)            1400-M Surge II
New Media Programmer/Analyst            UC Davis
Creative Communication Services         Davis, CA   95616
A Division of Information Technology    (916)752-0218;FAX-4655
University of California at Davis       jpgorrono_at_ucdavis.edu
Owner:Digital Video Discussion List	DIGVID-L_at_UCDAVIS.EDU

A 21-ellipsis salute in honor of Herb Caen:
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
... ... ... ... ...
______________________________________________________________
Received on Thu Feb 13 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US