Re: Insert image into Oracle 8.0.5

It depends on how you are accessing Oracle. You can't do it through SQLPlus as far as I know.
Using some programming language you need to create a parametized query where the LONG RAW
field is a parameter. Then fill the parameter by loading the file from your drive using a buffer
and stuffing the data into the field.

If you have streaming options available for filling in parameter fields, that's the best choice.
The OCI interface supports this but not all programming languages support the interface. I don't
work on solaris but I've done this with several languages (Java, Delphi, C/C++) on Windows.

John

Sebastien RUPIN wrote:

> Hello all,
>
> I have pictures in a directory (/export/home/pictures) on a solaris system
> and I would like to insert them in an Oracle table in a lon raw field.
>
> Is it possible ? If yes, how can I do that? Do I need a tool ?
>
> Thanks in advance
>
> Sebastien RUPIN
Received on Mon May 17 1999 - 19:53:11 CDT