From: "Niall Litchfield" Newsgroups: comp.databases.oracle.server References: <3B70986D.D6850141@hotmail.com> Subject: Re: uploading external docs on the database. Date: Wed, 8 Aug 2001 11:37:08 +0100 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2479.0006 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2479.0006 Lines: 43 Message-ID: <3b711664$0$8513$ed9e5944@reading.news.pipex.net> NNTP-Posting-Host: host9.audit-commission.gov.uk X-Trace: 997267044 reading.news.pipex.net 8513 193.128.236.219 X-Complaints-To: abuse@uk.uu.net I'm unclear what it is you are trying to achieve? If you are trying to store word and excel data etc in an oracle database then it is perfectly possible to store these documents in a BLOB field. Basically what you would do would be to find the length of the file and then append the data in in chuncks. -- Niall Litchfield Oracle DBA Audit Commission UK Legal disclaimer required by my employer **************************************************************************** ** This email contains information intended for the addressee only. It may be confidential and may be the subject of legal and/or professional privilege. Any dissemination, distribution, copyright or use of this communication without prior permission of the addressee is strictly prohibited. **************************************************************************** ** "Jitesh Chheda" wrote in message news:3B70986D.D6850141@hotmail.com... > Hi, > > I would like to upload external documents like Word, Excel to an oracle > document using PL/SQL. Is it possible. > Can some one provide a sample code to upload such text documents. > > Checked up a OTN but it does talk of Video and Audio files only. Would > like to know if non-binary files like *.doc, *.xls can be uploaded and > read from the DB. > > Any help in this matter would be appreciated. > > Thanks in Advance > > Jitesh >