| Blob retrieves documents from oracle database. [message #270401] |
Wed, 26 September 2007 15:05  |
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  |
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
[Updated on: Wed, 21 November 2007 15:04] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
