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].