Re: Insert image into Oracle 8.0.5
Date: Mon, 17 May 1999 20:53:11 -0400
Message-ID: <3740B9F7.F1A404B1_at_city-net.com>
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 Tue May 18 1999 - 02:53:11 CEST