Re: Saving MS Office Documents into an Oracle Database?

Jeremy,

You can do this with xmldb and web services. Tim Hall covers quite a bit of this.
https://oracle-base.com/articles/misc/xml-over-http

Seth

On Tue, Jun 11, 2019 at 1:54 PM Jeremy Ovenden <Jeremy_at_hireserve.com> wrote:

>
>
> 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
> *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?
>
>
>
> 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>
> 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>
> *Sent:* 11 June 2019 19:35
> *To:* Jeremy Ovenden <Jeremy_at_hireserve.com>
> *Cc:* Oracle Mailing List <oracle-l_at_freelists.org>
> *Subject:* Re: Saving MS Office Documents into an Oracle Database?
>
>
>
>
>
> [image: 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
>
>
>
>
> ------------------------------
>
> *From: *"Jeremy Ovenden" <Jeremy_at_hireserve.com>
> *To: *"Oracle Mailing List" <oracle-l_at_freelists.org>
> *Sent: *Tuesday, June 11, 2019 10:06:07 AM
> *Subject: *Saving MS Office Documents into an Oracle Database?
>
>
>
> 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
>
> jeremy
>
>
>
> --
>
> Andrew W. Kerber
>
> 'If at first you dont succeed, dont take up skydiving.'
>

--
http://www.freelists.org/webpage/oracle-l




image/png attachment: image001.png