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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: store image file in the database ?

Re: store image file in the database ?

From: Ramkumar Ganesan <ramkumarg_62_at_hotmail.com>
Date: Thu, 27 Jul 2000 13:03:31 EDT
Message-Id: <10571.113144@fatcity.com>


I vaguely recollect about having read / seen somewhere, an image type being converted to another using oracle forms 5.0 built-in procedures/functions. I suggest that you look in that direction.

>From: "Herman Susantio" <Sherman_at_bcsis.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: store image file in the database ?
>Date: Thu, 27 Jul 2000 05:56:47 -0800
>
>Hi,
>thanks for your response,
>
>what a good tool that can be use for querying image ?
>
>just to clarify your answer :
>
>if let's say i receive an image file called B001.JPEG with 60 KB size
>we can do conversion to oracle format data type / BLOB and store the file
>into database.
>how about the image size in the database, is it still 60 KB or could it be
>larger or smaller size ?
>
>and ur second comment :
> we can't convert the image in the database back to the JPEG file, is that
>what u mean ?
>CMIMW ;)
>
>TIA
>
>regards
> Herman
>
>
>
>
>----- Original Message -----
>To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
>Sent: Thursday, July 27, 2000 6:10 PM
>
>
> > Hi,
> >
> > You can use blob for the images, clob is for text.
> > We're using both, blob for .gif and .jpg and clob for
> > text.
> >
> > Yes, you can query the images with the proper tool.
> >
> > I do not think that you can change the format of an
> > image stored in Oracle.
> >
> > --- Herman Susantio <Sherman_at_bcsis.com> a écrit : >
> > hallo guys,
> > >
> > > anyone knows how to store JPEG file in a database ?
> > > and in what datatype ?
> > > BLOB ? CLOB ?
> > >
> > > can we do the query for the image ?
> > >
> > > and if the image is already in the database,
> > > can we convert it into JPEG file ?
> > >
> > > thank you
> > >
> > > regards
> > >
> > >
> > >
> > >
> > >
> > >
> > > --
> > > Author: Herman Susantio
> > > INET: Sherman_at_bcsis.com
> > >
> > > Fat City Network Services -- (858) 538-5051 FAX:
> > > (858) 538-5051
> > > San Diego, California -- Public Internet
> > > access / Mailing Lists
> > >
> > --------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an
> > > E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > > 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB
> > > ORACLE-L
> > > (or the name of mailing list you want to be removed
> > > from). You may
> > > also send the HELP command for other information
> > > (like subscribing).
> >
> >
> > =====
> > Stephane Paquette
> > DBA Oracle
> > stephane_paquette_at_yahoo.com
> > spaquette_at_houra.fr
> > (33) 01 53 93 06 50
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Get Yahoo! Mail - Free email you can access from anywhere!
> > http://mail.yahoo.com/
> > --
> > Author: =?iso-8859-1?q?paquette=20stephane?=
> > INET: stephane_paquette_at_yahoo.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
>
>--
>Author: Herman Susantio
> INET: Sherman_at_bcsis.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).


Received on Thu Jul 27 2000 - 12:03:31 CDT

Original text of this message

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