Re: Viewing Blobs

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Mon, 10 Feb 2003 15:15:24 -0800
Message-ID: <3E48328C.548EBF49@exesolutions.com>

Rogbaker wrote:

> I have an Oracle 8i database that is the db for a website. I want to
> have a table with a Blob field that will allow a user to upload a
> resume and store it in the database. I assume the resume could be a
> .jpg, a word .doc, .txt, .pdf, or whatever. I have managed to insert
> an image into my table:
> Name Null? Type
> ----------------------------------------- --------
> ----------------------------
> IMAGE_ID NUMBER(38)
> IMAGE_DATA BLOB
>
> but I don't know how to view it. Do I need Oracle Forms or something?
> Thanks for any tips or links to a website with a similar tutorial.

You don't 'need' Oracle Forms but Forms is one way to easily view them. I would caution you with respect to storing resume's as .jpg unless you have a huge amount of storage space to spare.

Daniel Morgan Received on Mon Feb 10 2003 - 17:15:24 CST