Re: Limitation of image files

>From: prajesh_at_ix.netcom.com (Jim Prajesh)
>Date: 16 May 1995 02:27:27 GMT
>Message-ID: <3p92ig$77j_at_ixnews4.ix.netcom.com>
 

>Would like to know of any limitations to the volume of data stored of
>image of forms using blobs. We expect to have about a million records
>of data with about that many forms that need to accessed if necessary.
>We are trying to decide if we should use Blobs or use CD ROM juke boxes
>to store the images of forms.
>Any comments?
>Thanks.

According to the Oracle 7.1 Server documentation, if you store an image in a
LONG or LONG RAW column, it can store up to 2 gigabytes. I've recently been able to store .BMPs into LONG RAW columns using the Forms 4 built-in READ_IMAGE_FILE, but it only accepts a handful of formats, though they're the most common (BMP, PCX, JFIF, TIFF, PICT). There are other ways to load large files into LONG RAWS, but they don't sound trivial, such as writing a C/C++ program using PRO*C. Received on Tue May 16 1995 - 00:00:00 CEST