Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> sqlload'ing pictures
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ñ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
![]() |
![]() |