By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,197 Members | 974 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,197 IT Pros & Developers. It's quick & easy.

Oracle 9i cannot display bfile image properly

P: n/a
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_header('image/gif');
DBMS_LOB.OPEN (mybfile, DBMS_LOB.LOB_READONLY);
LOOP
DBMS_LOB.READ (mybfile, l_amt, l_off,l_raw);
htp.prn(utl_raw.cast_to_varchar2(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
Jul 19 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.