Re: Loading jpg files in Oracle DataBase Table

I had the same problem with Access. It's a client "feature" that Access (and it sounds like Oracle Designer, too) helpfully de-compresses the JPEG before sending it off to the back end. What you need is some front-end tool that doesn't do the de-compression. For myself, and Access, I was pointed to a product called DBPix, which adds a new control to Access that sends the jpeg off to the back end 'raw', and thus a 15k jpg is stored as 15K (or near enough, given a bit of extent-rounding etc).

Not sure whether there's anything similar for Designer.

DBPix was available for trial download at http://www.oa-sys.demon.co.uk/ Maybe they can point you in the right direction for something that works with Designer (although their site says its just an ActiveX control, so maybe you can use it "as is".

Regards
HJR

--
----------------------------------------------
Resources for Oracle: http://www.hjrdba.com
===============================


"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.

>

>