| Retrieving MS Word doc stored in BLOB column [message #79079] |
Mon, 22 April 2002 06:33  |
Jazz
Messages: 9
Registered: April 2002
|
Junior Member |
|
|
Dear Friends,
I've been able to store my MS Word documents in BLOB columns using the DBMS_LOB package. (My platform is Oracle 8i + Forms 6i).
But now I would like to retrieve the MS Word documents to the File System so that the user can modify and save them back to the database. Could you please let me know how to do this.
I've been struggling for the past 2 days on this. Any help and pointers would be very appreciated.
Thanks,
Jazz
|
|
|
|
| Re: Retrieving MS Word doc stored in BLOB column [message #79080 is a reply to message #79079] |
Mon, 22 April 2002 06:45  |
S. La Rocca
Messages: 6
Registered: March 2002
|
Junior Member |
|
|
Hi Jazz,
for this reason we have enlarge forms with an own DLL (for web we do this with java) wich save the blob-Word-Document in a temp-dir on the computer and start the associated programm.
Forms get the blob-file from the database in pieces of 16k (see DBMS_LOB-package in 8i) and put them as hex-string to the DLL, which save them as a file.
After changing the MS Word document we do the same procedure backwards (reading with DLL in pieces and save as BLOB)
Good luck
Ciao Stephan
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
