Re: Storing images in Bfile fields

As far as I know you'd use the BLOB datatype for storing images.
Can't offer you a routine since I never used it...

-----Original Message-----
From: Carlos . <[email protected]>
To: Oracle <[email protected]>
Date: Monday, March 10, 2003 10:44 PM
Subject: [oracle] Storing images in Bfile fields


>
>I have a relatively small table in which I store information 
>about some products. It is like a small catalogue. 
>
>I'd like to include photos of the products. I have these photos 
>already stored in a different directory in my hard disk but I 
>would like to have the photos in the database instead.
>
>I have the catalogue table in an Oracle9i database table. One of 
>the fields of the table stores the location of the images and 
>that is how I show them, but this approach is not good enough 
>for Internet purposes, because I need to have the photos in the 
>server, not in my hard drive.
>
>Can you help me with an Oracle PL/SQL routine for storing the 
>images to the bfile field in my table?
>
>Carlitos
>
>
>ELIMINATE SPAM - FORBES PICK!
>Business Quality Web Email,
>Group Scheduling, & Team Tools
>http://www.norada.com/save
>
>
>---
>Change your mail options at http://p2p.wrox.com/manager.asp or 
>to unsubscribe send a blank email to %%email.unsub%%.


---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].