Re: How to insert BLOBs / images

There is no Oracle utility (to my knowledge) that is designed for this. I have been able to use SQL*Loader to load BLOB, with a little tweaking. The control file would look something like this (I am doing this from memory):

   load data
   infile test.blb "recsize=24628"
   into table test_tab
    (
    blob raw(24628),
    len constant 24628
    )

where "blob" refers to the LONG RAW column, "len" refers to the size of the BLOB, and 24628 is the filesize of the BLOB.

You can also write an OCI or Pro*C program to load the data.

Cheers,
Miguel Pascoe
miguel_pascoe_at_mercer.ca

In article <36680C35.8AB66A04_at_corel.ca>,   Craig Flichel <craigf_at_corel.ca> wrote:
> New to Oracle, how do I insert with a BLOB (image file, word file,
> spreadsheet, PDF, etc).
>
> What is the syntax?
> Is there a procedure that I pass params to?
>
> Craig
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Dec 07 1998 - 00:00:00 CET