RE: Saving MS Office Documents into an Oracle Database?

So crazy talk(?)…you could write some VB code that does a POST to an ORDS service that takes a HTTP request body saves that as a BLOB in a table, setting the mime type as it goes in.

I can help you with the ORDS bits, but not the VB code…

And then maybe use a macro to play that on demand?

Jeff

From: Jeremy Ovenden <Jeremy_at_hireserve.com> Sent: Tuesday, June 11, 2019 2:54 PM
To: Andrew Kerber <andrew.kerber_at_gmail.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?

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 <HYPERLINK "mailto:andrew.kerber_at_gmail.com"andrew.kerber_at_gmail.com> Sent: 11 June 2019 19:45
To: Jeremy Ovenden <HYPERLINK "mailto:Jeremy_at_hireserve.com"Jeremy_at_hireserve.com> Cc: Jeremiah Cetlin Wilton <HYPERLINK "mailto:jcwilton93_at_earlham.edu"jcwilton93_at_earlham.edu>; Oracle Mailing List <HYPERLINK "mailto:oracle-l_at_freelists.org"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 <HYPERLINK "mailto:Jeremy_at_hireserve.com"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 <HYPERLINK "mailto:jcwilton93_at_earlham.edu"jcwilton93_at_earlham.edu> Sent: 11 June 2019 19:35
To: Jeremy Ovenden <HYPERLINK "mailto:Jeremy_at_hireserve.com"Jeremy_at_hireserve.com> Cc: Oracle Mailing List <HYPERLINK "mailto:oracle-l_at_freelists.org"oracle-l_at_freelists.org> Subject: Re: Saving MS Office Documents into an Oracle Database?

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" <HYPERLINK "mailto:Jeremy_at_hireserve.com"Jeremy_at_hireserve.com> To: "Oracle Mailing List" <HYPERLINK "mailto:oracle-l_at_freelists.org"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 Received on Tue Jun 11 2019 - 21:03:31 CEST