Saving Word Files in DB

Saving Word Files in DB

Post by Your Nam » Sun, 31 Dec 1899 09:00:00



How do i go about saving a binary file, such as a word file in the database?
I may have to define datatypes as BLOBS but what about getting the file into
the datatype?  Any ideas?

Mark

 
 
 

Saving Word Files in DB

Post by Andreas Hund » Sun, 31 Dec 1899 09:00:00


In Oracle 8i it is very easy. Put the documents in the new Oracle File System
and from there by using the build in Package DBMS_LOB into the database.

Andreas

Your Name schrieb:

Quote:> How do i go about saving a binary file, such as a word file in the database?
> I may have to define datatypes as BLOBS but what about getting the file into
> the datatype?  Any ideas?

> Mark


 
 
 

Saving Word Files in DB

Post by b.. » Sun, 31 Dec 1899 09:00:00


OK.  It sounds easy.  But is it.  At the client, I have the document.  What do I
have to do to get in to the "Oracle File System"?  Do I FTP it to a directory so
that the LOB can pick it up?  Does DBMS_LOB really pick it up at the client
machine?  How about Web base vs. C/S?

> In Oracle 8i it is very easy. Put the documents in the new Oracle File System
> and from there by using the build in Package DBMS_LOB into the database.

> Andreas

> Your Name schrieb:

> > How do i go about saving a binary file, such as a word file in the database?
> > I may have to define datatypes as BLOBS but what about getting the file into
> > the datatype?  Any ideas?

> > Mark

 
 
 

1. Q: Lost DB due to system crash but saved DB files how to recreate DB.

Hi All,

I have a question and it goes somthing like this:

The System crashed and the person some how managed to save the data file form the
SQL 7.0 data file. They are the .MDF and the LDF files of the database.

Is it possible to recreate the database with these two files.

Thanks in advance.................

hai..............

2. search

3. Saving a word document in a Oracle DB

4. simple SELECT

5. Attempting to save Word document to Oracle DB field

6. mdf

7. Saving a Word Doc in a DB

8. DENVER Sybase DBA

9. Saving a Word file as a BLOB

10. how store word file in SQL7 DB

11. Generating word document files from embedded documents in Access or SQL Server DB.

12. Store large Word or PDF file in DB

13. Storing Word Files on DB