[askdba] Re: [dba_gurus] How to load & extract an Image(TIF) file into/from Oracle-BLOB?

  • From: "Justin Cave (DDBC)" <jcave@xxxxxxxxxxx>
  • To: "Thiagoo" <thiagoodba@xxxxxxxxx>, <dba_gurus@xxxxxxxxxxxxxxx>, <askdba@xxxxxxxxxxxxx>
  • Date: Thu, 12 May 2005 19:49:27 -0600

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@xxxxxxxxxxx>
Distributed Database Consulting, Inc.

-----Original Message-----
From: dba_gurus@xxxxxxxxxxxxxxx [mailto:dba_gurus@xxxxxxxxxxxxxxx] On
Behalf Of Thiagoo
Sent: Thursday, May 12, 2005 6:45 PM
To: dba_gurus@xxxxxxxxxxxxxxx; askdba@xxxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: [dba_gurus] How to load & extract an Image(TIF) file into/from

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

If this image file operation is successful, I have few Word/Execl files
to follow-on!

Any help in this regard is highly appreciated!


Best Regards,



Yahoo! Mail Mobile
 Take Yahoo! Mail with you! Check email on your mobile phone.

[Non-text portions of this message have been removed]

Yahoo! Groups Links

<*> To visit your group on the web, go to:

<*> To unsubscribe from this group, send an email to:

<*> Your use of Yahoo! Groups is subject to:

Other related posts: