RE: Storing images in Bfile fields

IMO, You'll need to create=20
1)	a storage location for your files on your web server.
2)	a table to contain the name, path, date, ... of each image
3)	a table to contain the categories of the above references
4)	a web page to accept incoming images and insert into the tables
listed above.




-----Original Message-----
From: Carlos . [mailto:[email protected]]=20
Sent: Monday, March 10, 2003 4:10 PM
To: Oracle
Subject: [oracle] Storing images in Bfile fields


I have a relatively small table in which I store information=20
about some products. It is like a small catalogue.=20

I'd like to include photos of the products. I have these photos=20
already stored in a different directory in my hard disk but I=20
would like to have the photos in the database instead.

I have the catalogue table in an Oracle9i database table. One of=20
the fields of the table stores the location of the images and=20
that is how I show them, but this approach is not good enough=20
for Internet purposes, because I need to have the photos in the=20
server, not in my hard drive.

Can you help me with an Oracle PL/SQL routine for storing the=20
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=20
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].