RE: Saving MS Office Documents into an Oracle Database?
Date: Tue, 11 Jun 2019 18:53:45 +0000
Message-ID: <DB6PR0701MB237583A24C7DB546D883B2AFD8ED0_at_DB6PR0701MB2375.eurprd07.prod.outlook.com>
Absolutely familiar with storing documents (rtf, doc, docx, pdf, html, xls, jpeg) in the database (either as BFILE or internally in BLOBs) and we do this already – and these are indexed using Oracle Text etc.
It was a bit of a tangential question perhaps for this list.
This question was really whether there was a way to insert something (an add in I guess) into MS Word to enable additional file-save / file-open options – i.e presenting Oracle like a network drive for example.
--
From: Andrew Kerber <andrew.kerber_at_gmail.com>
Sent: 11 June 2019 19:45
You can definitely store them as a blob. I am not sure if there is a way to read and write those directly to the database, but I expect there is some way to do it.
On Tue, Jun 11, 2019 at 1:42 PM Jeremy Ovenden <Jeremy_at_hireserve.com<mailto:Jeremy_at_hireserve.com>> wrote:
Heh thanks for reinforcing your view with a useful image.
Why would you store anything in a database? Presumably for centralised, secure access to data.
From: Jeremiah Cetlin Wilton <jcwilton93_at_earlham.edu<mailto:jcwilton93_at_earlham.edu>>
Sent: 11 June 2019 19:35
[cid:image001.png_at_01D5208E.5CB0E780]
Sorry... just being annoying.
The question would be: "why?"
Oracle is a transactional relational database. Why would we keep MS Office docs in there?
Jeremiah
Hi
Not sure if this is a the right group to ask for this assistance – but my google mojo has failed me thus far.
In MS Word you can save files to o/s but you can also save to e.g. Sharepoint and Teams – I was wondering if there is a means by which you can save directly into an Oracle DB?
Any pointers gratefully received.
Many thanks
--
'If at first you dont succeed, dont take up skydiving.'
--
To: Jeremy Ovenden <Jeremy_at_hireserve.com>
Cc: Jeremiah Cetlin Wilton <jcwilton93_at_earlham.edu>; Oracle Mailing List <oracle-l_at_freelists.org>
Subject: Re: Saving MS Office Documents into an Oracle Database?
To: Jeremy Ovenden <Jeremy_at_hireserve.com<mailto:Jeremy_at_hireserve.com>>
Cc: Oracle Mailing List <oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>>
Subject: Re: Saving MS Office Documents into an Oracle Database?
From: "Jeremy Ovenden" <Jeremy_at_hireserve.com<mailto:Jeremy_at_hireserve.com>>
To: "Oracle Mailing List" <oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>>
Sent: Tuesday, June 11, 2019 10:06:07 AM
Subject: Saving MS Office Documents into an Oracle Database?
jeremy
Andrew W. Kerber
http://www.freelists.org/webpage/oracle-l
