Oracle 9i cannot display bfile image properly

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Jack

    Oracle 9i cannot display bfile image properly

    Hi,
    We just upgrade from Oracle 8.1.7.4 to 9.2.0.4 in Solaris system. We
    found all images display with Bfile do not work in Oracle 9i but they
    work well in 8.1.7.4, no code change. could you please help us?
    Here is the source code:

    PROCEDURE bfileshow (bfilein bfile)
    IS
    mybfile bfile:=bfilein;
    --l_amt number default 30;
    l_amt BINARY_INTEGER := 1024;
    l_off INTEGER := 1;
    l_raw RAW(1024);
    BEGIN
    owa_util.mime_h eader('image/gif');
    DBMS_LOB.OPEN (mybfile, DBMS_LOB.LOB_RE ADONLY);
    LOOP
    DBMS_LOB.READ (mybfile, l_amt, l_off,l_raw);
    htp.prn(utl_raw .cast_to_varcha r2(l_raw));
    l_off:=l_off+l_ amt;
    END LOOP;
    DBMS_LOB.CLOSE (mybfile);
    EXCEPTION
    WHEN NO_DATA_FOUND THEN
    htp.p(sqlerrm);
    dbms_lob.close (mybfile);
    END bfileshow;

    Thanks,

    Jack
Working...