Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: storing TIFFs in 7.1.5?
Hi,
it can be done. The question is, how to get the files
in and out. In SQL*Plus, it's very difficult. You can
view and insert LONG-RAW columns as hex-dumps.
What I did was to write a Java-Client Program which allows
to store and retrieve binary files in Oracle Long-Raw columns.
Currently I use it to up- and download Word and Excel
documents to Oracle.
Greeintgs
Timo Biesenbach
Laith Suheimat wrote:
>
> Hello,
>
> I am running Oracle Server 7.1.5.2.3 and am investigating the possibility of
> storing images (TIFF files) in our database, either as a LONG RAW datatype,
> or using a pointer within a table to a file in the OS (OpenVMS AXP 6.2).
>
> Oracle Support inform me it can't be done, and the documentation says
> nothing, but I'm not so sure...
>
> I would appreciate any advice.
>
> Laith Suheimat
> l.suheimat_at_mdx.ac.uk
> Middlesex University, London
Received on Thu Mar 18 1999 - 08:30:11 CST