[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=
-BLOB?
Date: Thu, 12 May 2005 15:44:47 -0700 (PDT)

>=20
> Hi All,
>=20
> I want to load few image files into Oracle BLOB columns and later=20
> would Iike to extract it & write in a file.
>=20
> How to load & extract an Image(TIF) file into/from Oracle-BLOB?, am=20
> using dbms_lob.loadfromfile() to load into Oracle.
>=20
> I'm retrieving thru dbms_lob.read and writing using utl_file.put,=20
> I'm not able to write in a file.
>=20
> How can I retrieve this..?When I try to retrieve it say File Handle error.
>=20
> If this image file operation is successful, I have few Word/Execl=20
> files to follow-on!
>=20
> Any help in this regard is highly appreciated!
>=20
> TIA,
>=20
> Best Regards,
>=20
> THIAGU
>=20
>=20
>=20
>=20
>=20=09=09
> ---------------------------------
> Yahoo! Mail Mobile
>   Take Yahoo! Mail with you! Check email on your mobile phone.



Good Luck..Subodh Deshpande

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
Experience Is Knowledge
Wisdom Is Philosophy
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D








--=20
_______________________________________________
NEW! Lycos Dating Search. The only place to search multiple dating sites at=
 once.
http://datingsearch.lycos.com


Other related posts: