Xref: alice comp.databases.oracle.misc:40701 comp.databases.oracle.server:65236 comp.databases.oracle.tools:31681 Path: alice!news-feed.fnsi.net!hammer.uoregon.edu!arclight.uoregon.edu!wn4feed!worldnet.att.net!144.212.100.101!newsfeed.mathworks.com!news.maxwell.syr.edu!nntp2.deja.com!nnrp1.deja.com!not-for-mail From: Michael Stelly Newsgroups: comp.databases.oracle.tools,comp.databases.oracle.server,comp.databases.oracle.misc Subject: Re: Storing Word Files on DB Date: Fri, 10 Sep 1999 04:18:51 GMT Organization: Deja.com - Share what you know. Learn what you don't. Lines: 44 Message-ID: <7ra0r4$jrv$1@nnrp1.deja.com> References: <37D82AF4.B7F8F85@vossnet.co.uk> <7r9n29$d0j$1@nnrp1.deja.com> X-Article-Creation-Date: Fri Sep 10 04:18:51 1999 GMT X-Http-User-Agent: Mozilla/4.61 [en] (WinNT; U) X-Http-Proxy: 1.0 x26.deja.com:80 (Squid/1.1.22) for client 205.227.43.13 X-MyDeja-Info: XMYDJUIDm_stelly In article <7r9n29$d0j$1@nnrp1.deja.com>, shmurphy@my-deja.com wrote: > In article <37D82AF4.B7F8F85@vossnet.co.uk>, > Mark Gumbs wrote: > > Hi, > > > > Our client requiers the functionality of storing word files on the > > database side. > > Which oracle packages, if any, allows us to do this. I think BLOBs > may > > play a part somewhere. > > > > Mark > > > > > Mark, I'm doing exactly this at my client's site. However, I'm using a > Visual Basic front end, Oracle 8.0 database, and Microsoft ODBC drivers. > I'm saving the document data as LONG_RAW (binary) and letting Word > convert it back when it's reloaded later. If you're using Oracle's > drivers, you'd probably use CLOB. I'd be happy to e-mail you some code. > E-mail me at shmurphy@wfubmc.edu tomorrow (9/10/99) if interested > [although not sure of your time zone difference]. > -Murf > > Sent via Deja.com http://www.deja.com/ > Share what you know. Learn what you don't. > I think that Mark's first assumption is correct. Word files are stored in binary format, so I would use a BLOB vs. CLOB. My understanding is that CLOBS are used for very large (4gb) character files. If you can reference Feuerstein's PL/SQL Programming book, he gives a detailed explanation about the use of large objects vs. LONG's or RAW's. Good luck, -- Michael Stelly m_stelly@my-deja.com Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.