From: "George Barbour" Newsgroups: comp.databases.oracle.server References: <3B70986D.D6850141@hotmail.com> Subject: Re: uploading external docs on the database. Date: Wed, 8 Aug 2001 09:20:27 +0100 Lines: 38 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 NNTP-Posting-Host: esk2186.ct.edinbr.gecm.com Message-ID: <3b70f38e$1@pull.gecm.com> X-Trace: 8 Aug 2001 09:08:46 GMT, esk2186.ct.edinbr.gecm.com Jitesh Chheda, You could have a look in Metalink. I found the Note:113471.1 more than useful. Here is the authors prescript. /* This package was written by Audun V. Nes The intention of this sample is to show the File Upload/Download capabilities of the PL/SQL gateway shipped with iAS. Last updated 24th of May 2000. */ I strongly recommend looking at Audun's code, and if your looking, thank again Audun. George Barbour "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 >