Re: Loading Image Data into Oracle

James K. Anderson MRD-IM wrote:
>
> How to I load an image into Oracle? I know how to create a table
> to hold the data, but do I use an INSERT command to insert a new
> record? If so, how do I make a reference to the file with the image
> in the insert command?
>
> Any help is greatly appreciated, as I am stumped.
>
> Thanks,
> Jim Anderson

I don't think this can be done with interactive SQL commands. One way that we've done it is to:

1. upload the image file onto the Oracle server machine using binary mode ftp (if it's not there already).
2. Write a C program which reads the image file and inserts the data into the database.