Re: Pictures(JPG) files in ORACLE

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 6 Jun 2002 05:44:11 -0700
Message-ID: <a20d28ee.0206060444.2a9fa057@posting.google.com>

pakiyabhai_at_deadman.com (Pakiya Bhai) wrote in message news:<f35dbc0e.0206052055.2e8bd433_at_posting.google.com>...
> i am using oracle9i as the backend/developer2000 as the frontend
>
>
>
> ok , i have to create a small catalogue , i need to have a field which
> display pictures(RAW I suppose).....
>
> NOw the catch , i dont' want oracle to store the pic , all the pics
> are stored in say c:\mypics , oracle should only display the picture
> from there , should not store it in the datbase, becoz then the size
> of the database will increase.
>
> Is this possible ??

please do not 'suppose' RAW. You need to use the BFILE datatype (described in your documentation) which has been introduced in 8.0

Hth

Sybrand Bakker
Senior Oracle DBA Received on Thu Jun 06 2002 - 07:44:11 CDT