Re: BLOB & JPEG images

If you are going to store these images as Long Raw's it is essential that the table storing these has one primary/unique key as the reference to the blob and the blob itself in another column e.g. a two columned table.

Long Raws are renowned for using up resources. Be careful if using ODBC to access the Long Raw datatypes, can be problematic for some clients in a CS environment. Also Oracle on NT 3.51 did have problems with LONG's.

Regs.

 In article <32A67822.73F_at_qrcsun.qrc.org>, "Lun Wing San (Oracle)" <wslun_at_qrcsun.qrc.org> writes
>Harshad Bahirsheth wrote:
>> 1. Store the image files in a seperate directory and store the path names
>> in the Oracle database OR
>> 2. Sotre the image in the Oracle database as a BLOB (LONG RAW) and not
>> incur a significant penalty.
>
> I have a comment on point two. You need to take care the space allocation as
>it will
>run out of the space easily.
>
>---
>Name : Lun Wing San
>Title : Oracle Application Developer of Hong Kong Productivity Council
> Oracle Database Administrator and System Administrator of QRC
>Phone : (852)27885841
 

-- 
Robert Dring