Home » Developer & Programmer » JDeveloper, Java & XML » Blob retrieves documents from oracle database.
Blob retrieves documents from oracle database. [message #270401] Wed, 26 September 2007 15:05 Go to next message
silva03
Messages: 3
Registered: September 2007
Junior Member
Hi
All


I got a table with a blob collum, wiht many documents and now i need to output they on my disc.
How can i do that?

Oracle 9i, jdk5.

Here is my query:

select mydocuments, myphoto from gpt_photo where photo_code = 10



Here
Thansk
Re: Blob retrieves documents from oracle database. [message #282383 is a reply to message #270401] Wed, 21 November 2007 15:03 Go to previous message
psix666
Messages: 51
Registered: April 2007
Location: Azerbaijan
Member

Hi.

I know that it's too late but anyway. Anyone other can use this:

try to find "LobUtils" in google.
This is a package with 4 procedures in it clob2file, file2clob, blob2file, file2blob.

Thanks. Bye.

P.S. If someone can't find just write to my email and i will send this package to you.

~update

i forgot to say that files will be created on the server side
Razz

[Updated on: Wed, 21 November 2007 15:04]

Report message to a moderator

Previous Topic: Java external procedure parameters
Next Topic: how to connect oracle 9i Database using java coding
Goto Forum:
  


Current Time: Tue Dec 10 03:18:44 CST 2024