473,320 Members | 1,859 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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_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
0 1777

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: susmita_ganguly | last post by:
Hi I am trying to upgrade from oracle 8i to oracle 9i on the same server ..I don't know much abt migration . Can anyone help me out. Thanks. Susmita
8
by: baustin75 | last post by:
Posted: Mon Oct 03, 2005 1:41 pm Post subject: cannot mail() in ie only when debugging in php designer 2005 -------------------------------------------------------------------------------- ...
9
by: AnandaSim | last post by:
Hi All, I've had Access 97, 2000 connections to the corporate Oracle database for a few years now - but seldom use it. When I did use it years ago, performance was not fast but the features were...
2
by: Crazy Cat | last post by:
Hi all, I am having trouble getting linked Oracle 9 server in MS SQL Server 2005 Express to work properly. My machine is running Windows XP. The Microsoft and Oracle OLE DB Providers have...
2
by: K. A. | last post by:
I'm trying to write a web site for storing staff ID's together with their photos using a PHP form. A user of the site should be able to enter his ID, name, and select a file from a directory as his...
2
by: nicknme | last post by:
I have to incorporate the functionality of attachments as in mails using PLSQL.I am unable to find a soln for this..Regular procs using BFILE is not an option for me as the file will be in any local...
5
by: jonceramic | last post by:
Hi All, I started developing in Access, and people took notice and so we're starting to migrate into our corporate's bigger Oracle system. I'll still be using my developed Access front ends,...
0
debasisdas
by: debasisdas | last post by:
This Article contains some useful tips in oracle PL/SQL in 9i/10g which the forum members might find useful Advantages of PL/SQL =================== 1.Support for SQL 2.Support for...
0
by: Jack | last post by:
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...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.