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 -> Re: Loading jpg files in Oracle DataBase Table

Re: Loading jpg files in Oracle DataBase Table

From: Vladimir M. Zakharychev <bob_at_dpsp-yes.com>
Date: Tue, 12 Mar 2002 12:54:43 +0300
Message-ID: <a6kj66$am8$1@babylon.agtel.net>

  1. Why in the world are you still using LONGs? Translate them to BLOBs ASAP. LONGs are just plain BAD.
  2. It seems that the file is decompressed or otherwise preprocessed when loaded. Try using different function that can upload raw binary data (I am no good with Designer and don't know if such function exists there) as is without any processing.
-- 
Vladimir Zakharychev (bob@dpsp-yes.com)                http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.


"rc" <none> wrote in message news:a6kb4k$7h8m06_at_news1s.iddeo2.es...

> The problem is when we save the file into de table (long_raw type field),
> the size of the table is 5 or 6 times bigger . We use the READ_FILE_IMAGE
> function of Oracle Designer to load the file like an image.
> Files in jpg are 15 Kb size, while when they are into the table are about
> 100 Kb.
>
> Please, We need to know if there is another way to load files more
> compressed
>
> TIA.
>
>
Received on Tue Mar 12 2002 - 03:54:43 CST

Original text of this message

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