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
Messages: 3
Registered: September 2007
Junior Member

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

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
Messages: 51
Registered: April 2007
Location: Azerbaijan


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.


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

[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 Jul 25 12:01:01 CDT 2017

Total time taken to generate the page: 0.14670 seconds