Insert / Select JPEG Images to / From Oracle 8.1.5

I need to be able to store 296 large JPEG image files in an Oracle (8.1.5, on NT 4.0 sp5) table and at a later time select the data out so that Cold Fusion code can display the image in the web browser. That makes two distinct tasks:

1. Write (or: beg/borrow,..) some PL/SQL to convert the contents of the JPEG files into some kind of Oracle data type such as long or raw,... and insert that data into the table (along with a primary key). This will be a one time process.
2. Select the data out of the Oracle table into something that Cold Fusion code could display in the web browser.

Any Ideas on either task ?

Thanks,
Rock Cogar.

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Aug 23 1999 - 11:28:20 CDT