Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Storing/Accessing GIF Files in Oracle

Storing/Accessing GIF Files in Oracle

From: John Schuerman <john_schuerman_at_NOSPAM.mgic.com>
Date: Fri, 20 Aug 1999 10:37:21 -0500
Message-ID: <37BD7630.932788B8@NOSPAM.mgic.com>


I'm using Oracle 7.3.3.4 and have been asked to research storing GIF files in the Oracle database.

1. Is this do-able in Oracle7?
2. Is the only DATATYPE option the LONG RAW datatype?
3. Would it be better to store a "location pointer" in the database and
actually store the GIF file in a directory. The application that plans on using the GIF files runs on a Solaris 2.6 machine and the Oracle database resides on a AIX machine (not that the different machines make a difference.) But I'm wondering if storing the GIF file in a directory on the Sun machine where the application resides would be more efficient then storing and sending the GIF file over the network.

Any help would be greatly appreciated. Thank You. Received on Fri Aug 20 1999 - 10:37:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US