How to save a word/excel doc in Oracle [message #57760] |
Fri, 04 July 2003 04:17 |
Roy George
Messages: 7 Registered: March 2001
|
Junior Member |
|
|
Hello,
I have a special requirement from the customer. They need to save word/excel/text/picture docs in database. How will we do that? did anybody tried this before? Any help will be greatly appreciated.
Thanks,
Roy
|
|
|
Re: How to save a word/excel doc in Oracle [message #57808 is a reply to message #57760] |
Tue, 08 July 2003 13:10 |
Jim Berg
Messages: 2 Registered: July 2003
|
Junior Member |
|
|
You can store the docs in a BLOB field in the database. I just finished a project where we had Word, Excel and PDF's that we moved off a Windows share into an 8.1.7 database. We used Java but the techniques are the same if you are using VB. Look up the DBMS_LOB built-in package or the jdbc programming guide for examples of how to do this.
|
|
|