Storing images in Bfile fields

"Carlos ." <[email protected]> Mon, 10 Mar 2003 21:09:38 -0000
Newsgroups gmane.comp.db.oracle.devel
Message-ID <LYRIS-1796914-906091-2003.03.10-21.07.12--gcdod-oracle#[email protected]>
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 protected].