how to display BLOB image on web page

From: Greg Gale <ggpro_at_yahoo.com>
Date: 26 Jun 2001 16:51:10 -0700
Message-ID: <21473820.0106261551.38eb593c_at_posting.google.com>

The following code works adequately to display only the blob image on a web page but when I add other html text to the same page, the image is printed as text, it is not displayed as an image.

How do I display the image along with text on a web page?

it doesn't work like this:

---

htp.prn('this is an image');
owa_util.mime_header( 'image/gif' );
begin

    loop

        dbms_lob.read( l_lob, l_amt, l_off, l_raw );
        htp.prn( utl_raw.cast_to_varchar2( l_raw ) );
        l_off := l_off+l_amt;
        l_amt := 4096;

    end loop;
exception

Thank you. -Greg- Received on Wed Jun 27 2001 - 01:51:10 CEST