| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: [dba_gurus] How to load & extract an Image(TIF) file into/from Oracle-BLOB?
First, error numbers and a code sample would be helpful.
Second, you need to be using 9i or later to be able to read & write binary data via UTL_FILE. You also need to use the PUT_RAW function rather than using PUT.
That doesn't explain the file handle error-- are you sure that you opened the file first?
Justin Cave <jcave_at_ddbcinc.com>
Distributed Database Consulting, Inc.
http://www.ddbcinc.com
-----Original Message-----
From: dba_gurus_at_yahoogroups.com [mailto:dba_gurus_at_yahoogroups.com] On
Behalf Of Thiagoo
Sent: Thursday, May 12, 2005 6:45 PM
To: dba_gurus_at_yahoogroups.com; askdba_at_freelists.org
Cc: oracle-l_at_freelists.org
Subject: [dba_gurus] How to load & extract an Image(TIF) file into/from
Oracle-BLOB?
Hi All,
I want to load few image files into Oracle BLOB columns and later would Iike to extract it & write in a file.
How to load & extract an Image(TIF) file into/from Oracle-BLOB?, am using dbms_lob.loadfromfile() to load into Oracle.
I'm retrieving thru dbms_lob.read and writing using utl_file.put, I'm not able to write in a file.
How can I retrieve this..?When I try to retrieve it say File Handle error.
If this image file operation is successful, I have few Word/Execl files to follow-on!
Any help in this regard is highly appreciated!
TIA, Best Regards,
THIAGU =20
=09
[Non-text portions of this message have been removed]
=20
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/dba_gurus/
<*> To unsubscribe from this group, send an email to:
dba_gurus-unsubscribe_at_yahoogroups.com
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
=20
-- http://www.freelists.org/webpage/oracle-lReceived on Thu May 12 2005 - 21:48:54 CDT
 |
 |