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

  • From: "Subodh Deshpande" <subodh_deshpande@xxxxxxxxx>
  • To: askdba@xxxxxxxxxxxxx
  • Date: Fri, 13 May 2005 00:51:16 -0500

hi Thiagoo,

on oracle site there are some working example related to it, they have show=
n it using java beans.=20

metalink says use web_util, pdf is available there have a alook at it..

thanx in advance..subodh=20
----- Original Message -----
From: Thiagoo <thiagoodba@xxxxxxxxx>
To: dba_gurus@xxxxxxxxxxxxxxx, askdba@xxxxxxxxxxxxx
Subject: [askdba] How to load & extract an Image(TIF) file into/from Oracle=
Date: Thu, 12 May 2005 15:44:47 -0700 (PDT)

> Hi All,
> I want to load few image files into Oracle BLOB columns and later=20
> would Iike to extract it & write in a file.
> How to load & extract an Image(TIF) file into/from Oracle-BLOB?, am=20
> using dbms_lob.loadfromfile() to load into Oracle.
> I'm retrieving thru dbms_lob.read and writing using utl_file.put,=20
> 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=20
> files to follow-on!
> Any help in this regard is highly appreciated!
> TIA,
> Best Regards,
> ---------------------------------
> Yahoo! Mail Mobile
>   Take Yahoo! Mail with you! Check email on your mobile phone.

Good Luck..Subodh Deshpande

Experience Is Knowledge
Wisdom Is Philosophy

NEW! Lycos Dating Search. The only place to search multiple dating sites at=

Other related posts: